--------------------------------------------------------------------
      name:  <unnamed>
       log:  /home/dcohen/work/202410_rents_replication/logs/01-01.l
> og
  log type:  text
 opened on:  18 Oct 2024, 11:08:55

. ******************************************************************
> **************
. *** SETUP
. ******************************************************************
> **************
. 
. * Specify version
. version 15

. clear all 

. set maxvar 7500


. 
. * Set global macro for input and output paths
. global longpath "/home/dcohen/soep-data/soep.v35/stata_de+en"

. global savepath "/home/dcohen/work/202410_rents_replication/dat/pr
> oc-data"

. 
. ******************************************************************
> **************
. *** Merge Data Sets
. ******************************************************************
> **************
. 
. * Load individual-level data from PL
. use "$longpath/pl.dta", clear
(SOEP-Core, v35, doi:10.5684/soep-core.v35)

. sort pid syear

. 
. * Merge with data on survey history from PPFADL
. merge 1:1 pid syear using "$longpath/ppathl.dta"

    Result                      Number of obs
    -----------------------------------------
    Not matched                       419,010
        from master                         0  (_merge==1)
        from using                    419,010  (_merge==2)

    Matched                           682,447  (_merge==3)
    -----------------------------------------

. /*
> all obs in master matched
> */
. drop if _merge == 2
(419,010 observations deleted)

. drop _merge

. 
. 
. * Merge with generated individual data from PGEN
. merge 1:1 pid syear using "$longpath/pgen.dta"
(variable syear was long, now double to accommodate using data's
       values)

    Result                      Number of obs
    -----------------------------------------
    Not matched                         6,603
        from master                        45  (_merge==1)
        from using                      6,558  (_merge==2)

    Matched                           682,402  (_merge==3)
    -----------------------------------------

. /*
> 45 obs in master not matched (from 1984); 
> keep those (imputable, but likely irrelevant)
> */
. drop if _merge == 2
(6,558 observations deleted)

. drop _merge

. 
. 
. * Merge with time-invariant individual data from PBRUTTO
. merge 1:1 pid syear using "$longpath/pbrutto.dta", keepusing(gebur
> t_v2)
(label sex already defined)
(label intid already defined)
(label sex_EN already defined)
(label intid_EN already defined)

    Result                      Number of obs
    -----------------------------------------
    Not matched                       404,394
        from master                         0  (_merge==1)
        from using                    404,394  (_merge==2)

    Matched                           682,447  (_merge==3)
    -----------------------------------------

. /*
> all obs in master matched
> */
. drop if _merge == 2
(404,394 observations deleted)

. drop _merge

. 
. * Merge with data on first and last job from BIOJOB
. merge m:1 pid using "$longpath/biojob.dta", ///
>       keepusing(isco88 fjselfe fjsefsiz einstieg_artk einstieg_pbi
> o nacefj ///
>                     nacelj occljob ljblue ljselfe ljsefsiz ljwhite
>  ljcivs ///
>                                 yearlast einstieg_artk einstieg_pb
> io)

    Result                      Number of obs
    -----------------------------------------
    Not matched                         6,496
        from master                     5,020  (_merge==1)
        from using                      1,476  (_merge==2)

    Matched                           677,427  (_merge==3)
    -----------------------------------------

. /*
> 5,061 obs in master not matched. Possibly those that haven't compl
> eted the 
> biograhpy interview yet. Auxiliary information, hence not critical
> .
> */
. drop if _merge == 2
(1,476 observations deleted)

. drop _merge

. 
. * Merge with rolling household data from HL
. merge m:1 hid syear using "$longpath/hl.dta", ///
>       keepusing(hlc0001 hlc0002 hlc0005_h hlc0043 hlf0135 hlf0153_
> h hlk0007 ///
>           hlk0044 hlc0008_h hlf0606 hlf0632 hlc0017 hlf0107_h hlf0
> 108_* hlf0126 ///
>           hlf0127 hlf0128 hlf0129 hlf0130 hlf0131 hlf0132 hlf0526 
> hlf0151 ///
>           hlf0152 hlf0153_h hlf0523)
(label intid_EN already defined)
(label instrument_EN already defined)
(label intid already defined)
(label instrument already defined)

    Result                      Number of obs
    -----------------------------------------
    Not matched                           736
        from master                       703  (_merge==1)
        from using                         33  (_merge==2)

    Matched                           681,744  (_merge==3)
    -----------------------------------------

. /*
> 703 obs in master not matched (between 2003-2018); keep those (imp
> utable)
> */
. drop if _merge == 2
(33 observations deleted)

. drop _merge

. 
. * Merge with generated household data from HGEN
. merge m:1 hid syear using "$longpath/hgen.dta", ///
>       keepusing(hghinc hgtyp1hh hgtyp2hh hgacquis hgmoveyr hgnoren
> t hgowner ///
>                     hgreduc hgrent hgrentinfo hgreval hgroom hgrsu
> bs hgseval ///
>                                 hgsize hgutil hgcnstyrmax hgcnstyr
> min hgcondit hghinc hgcondit)
(label iyear already defined)
(label iyear_EN already defined)

    Result                      Number of obs
    -----------------------------------------
    Not matched                           736
        from master                       703  (_merge==1)
        from using                         33  (_merge==2)

    Matched                           681,744  (_merge==3)
    -----------------------------------------

. /*
> 703 obs in master not matched (between 2003-2018); keep those (imp
> utable)
> */
. drop if _merge == 2
(33 observations deleted)

. drop _merge

. 
. * Merge with asset information from HWEALTH
. merge m:1 hid syear using "$longpath/hwealth.dta", ///
>       keepusing(p100h0 p010h* p001h* p011h* e100h0 e010h* e001h* w
> 010h* ///
>                     w001h* w011h* n010h* n001h* n011h*)
(variable hid was long, now double to accommodate using data's
       values)

    Result                      Number of obs
    -----------------------------------------
    Not matched                       585,383
        from master                   585,373  (_merge==1)
        from using                         10  (_merge==2)

    Matched                            97,074  (_merge==3)
    -----------------------------------------

. /*
> many obs in master not matched, because variable only available in
> 2002, 2007, 2012, 2017; substantial missings in 2012 (8.90%) and 2
> 017 (17.44%)
> */
. drop if _merge == 2
(10 observations deleted)

. drop _merge

. 
. * Merge with all variables from PEQUIV
. merge 1:1 pid syear using "$longpath/pequiv.dta"

    Result                      Number of obs
    -----------------------------------------
    Not matched                       284,110
        from master                       703  (_merge==1)
        from using                    283,407  (_merge==2)

    Matched                           681,744  (_merge==3)
    -----------------------------------------

. drop if _merge == 2
(283,407 observations deleted)

. drop _merge

. /*
> 703 obs in master not matched (between 2003-2018); keep those (imp
> utable)
> */
. 
. * Merge with all variables from REGIONL
. merge m:1 hid syear using "$longpath/regionl.dta"

    Result                      Number of obs
    -----------------------------------------
    Not matched                       150,492
        from master                         0  (_merge==1)
        from using                    150,492  (_merge==2)

    Matched                           682,447  (_merge==3)
    -----------------------------------------

. drop if _merge == 2
(150,492 observations deleted)

. drop _merge

. /*
> all obs in master matched
> new vars: regbez-kr_gdp_pc
> */
. 
. * Merge with all variables from MOVEDIST
. merge 1:1 pid syear using "$longpath/movedist.dta"

    Result                      Number of obs
    -----------------------------------------
    Not matched                       543,935
        from master                   225,802  (_merge==1)
        from using                    318,133  (_merge==2)

    Matched                           456,645  (_merge==3)
    -----------------------------------------

. drop if _merge == 2
(318,133 observations deleted)

. drop _merge

. /*
> 225,802 obs in master not matched; all <= year 2000, thus won't be
>  used anyway
> new vars: res_move - chg_zip
> */
. 
. * Merge with residency information from HBRUTTO
. merge m:1 hid syear using "$longpath/hbrutto.dta", ///
>       keepusing(wein_v3)
(label sample1 already defined)
(label sampreg already defined)
(label hpmax already defined)
(label bula already defined)
(label luecke already defined)
(label intid already defined)
(label sample1_EN already defined)
(label sampreg_EN already defined)
(label hpmax_EN already defined)
(label luecke_EN already defined)
(label intid_EN already defined)

    Result                      Number of obs
    -----------------------------------------
    Not matched                        54,260
        from master                         0  (_merge==1)
        from using                     54,260  (_merge==2)

    Matched                           682,447  (_merge==3)
    -----------------------------------------

. /*
> all obs in master matched
> */
. drop if _merge == 2
(54,260 observations deleted)

. drop _merge

. 
. ******************************************************************
> **************
. *** Recodes
. ******************************************************************
> **************
. 
. *** ID Variables
. * Create general, comparable variables
. gen long id = pid

. gen long hh_id = hid

. gen year = syear

. 
. * Wave and country identifier
. egen wave = group(year)

. 
. *** Weights
. gen lweight = pbleib 

. gen xweight1 = phrf 

. gen xweight2 = phrf0 /* Hochrechnungsfaktor fuer Ursprungsstichpro
> ben (Welle 1)*/

. gen xweight3 = phrf1 /* Hochrechnungsfaktor ohne Ursprungsstichpro
> ben (Welle 1)*/

. 
. * First interview
. gen first = year == erstbefr

. 
. *** Demographics
. * Gender
. gen fem = (sex ==2 ) if sex >= 0 & !missing(sex)

. 
. * Birthyear/Age
. gen born = geburt_v2 if geburt_v2 >= 0 & !missing(geburt_v2)
(12,300 missing values generated)

. gen age = d11101 if d11101 >= 0 & !missing(d11101)
(706 missing values generated)

. replace age = year - born if missing(age)
(703 real changes made)

. 
. * Age categories
. la def age5 1 "< 25" 2 "25-34" 3 "35-44" 4 "45-54" 5 ">=55"

. gen age5 = .
(682,447 missing values generated)

. replace age5 = 1 if age < 25
(82,849 real changes made)

. replace age5 = 2 if inrange(age, 25, 34)
(116,504 real changes made)

. replace age5 = 3 if inrange(age, 35, 44)
(139,354 real changes made)

. replace age5 = 4 if inrange(age, 45, 54)
(128,476 real changes made)

. replace age5 = 5 if age >= 55 & !missing(age)
(215,261 real changes made)

. la val age5 age5

. 
. * Migration Background
. gen migr3 = inlist(migback, 1, 2) if migback >= 0  & !missing(migb
> ack)

. 
. * Bundesland (numerical codes correspond to GLES)
. clonevar bl = bula

. 
. * East/West Indicator
. gen east = (sampreg == 2)

. 
. * Citizenship
. gen citizen = (pgnation == 1) if pgnation >= 0 
(91 missing values generated)

. 
. * Role in household
. clonevar hh_role = d11105
(703 missing values generated)

. 
. *** Household Composition
. * Household members
. gen hh_mmb = d11106 if d11106 >= 0  & !missing(d11106)
(703 missing values generated)

. 
. * Children in HH
. gen hh_num_child = d11107 if d11107 >= 0  & !missing(d11107)
(703 missing values generated)

. gen hh_prop_child = hh_num_child / hh_mmb
(703 missing values generated)

. 
. * Household Typology
. la def hh_comp 1 "Single" 2 "Partnered" 3 "Single Parent" 4 "Partn
> ered Parent"

. gen hh_comp = hgtyp1hh
(703 missing values generated)

. recode hh_comp (4 5 6 7 8 = 4)
(190,656 changes made to hh_comp)

. la val hh_comp hh_comp

. 
. 
. *** Socio-economic Indicators
. * Education
. la def edu5 1 "<= Lower Secondary" 2 "Upper Secondary" ///
>             3 "Post-Secondary Non-Tertiary" 4 "Higher Vocational" 
> ///
>                         5 "Higher Education"

. gen edu5 = pgisced97 - 1 if pgisced97 >= 1  & !missing(pgisced97)
(25,197 missing values generated)

. recode edu5 (0 = 1)
(22,736 changes made to edu5)

. la val edu5 edu5

. 
. * Monthly Personal Labor Income
. gen pinc_labor = i11110 / 12 if i11110 >= 0 & !missing(i11110)
(17,987 missing values generated)

. gen log_pinc_labor = log(pinc_labor + 1)
(17,987 missing values generated)

. /*
> Labor earnings include wages and salary from all employment includ
> ing
> training, primary and secondary jobs, and self-employment, plus in
> come
> from bonuses, overtime, and profit-sharing.
> Specifically labor earnings is the sum of income from primary job,
>  secondary
> job, self-employment, 13th month pay, 14th month pay, Christmas bo
> nus
> pay, holiday bonus pay, miscellaneous bonus pay, and profit-sharin
> g income.
> */
. 
. * Monthly Personal Total Income
. global pinc_components = "ijob1 ijob2 iself ioldy iwidy icomp iprv
> p iunby iunay isuby ieret imaty istuy imilt ialim iachm ichsu ispo
> u ielse iwith i13ly i14ly ixmas iholy igray iothy itray idemy igrv
> 1 ismp1 iciv1 iwar1 iagr1 iguv1 ivbl1 icom1 iprv1 irie1 iaus1 ilib
> 1 ison1 igrv2 ismp2 iciv2 iwar2 iagr2 iguv2 ivbl2 icom2 iprv2 irie
> 2 iaus2 ilib2 ison2"

. 
. foreach X in $pinc_components {
  2.   mvdecode `X', mv(-1 -2 -3 = . \ -5 = .a\ -8 = .b)
  3. }
       ijob1: 17286 missing values generated
       ijob2: 17284 missing values generated
       iself: 17284 missing values generated
       ioldy: 17284 missing values generated
       iwidy: 17284 missing values generated
       icomp: 8674 missing values generated
       iprvp: 8674 missing values generated
       iunby: 17284 missing values generated
       iunay: 17284 missing values generated
       isuby: 17284 missing values generated
       ieret: 8674 missing values generated
       imaty: 17284 missing values generated
       istuy: 17284 missing values generated
       imilt: 8674 missing values generated
       ialim: 8674 missing values generated
       iachm: 8674 missing values generated
       ichsu: 8674 missing values generated
       ispou: 8674 missing values generated
       ielse: 17284 missing values generated
       iwith: 8674 missing values generated
       i13ly: 17284 missing values generated
       i14ly: 17284 missing values generated
       ixmas: 17284 missing values generated
       iholy: 17284 missing values generated
       igray: 17284 missing values generated
       iothy: 17329 missing values generated
       itray: 8674 missing values generated
       idemy: 13638 missing values generated
       igrv1: 17284 missing values generated
       ismp1: 17329 missing values generated
       iciv1: 17329 missing values generated
       iwar1: 17329 missing values generated
       iagr1: 17329 missing values generated
       iguv1: 17329 missing values generated
       ivbl1: 17329 missing values generated
       icom1: 17329 missing values generated
       iprv1: 8674 missing values generated
       irie1: 8674 missing values generated
       iaus1: 8674 missing values generated
       ilib1: 8674 missing values generated
       ison1: 17329 missing values generated
       igrv2: 17329 missing values generated
       ismp2: 17329 missing values generated
       iciv2: 17329 missing values generated
       iwar2: 17329 missing values generated
       iagr2: 17329 missing values generated
       iguv2: 17329 missing values generated
       ivbl2: 17329 missing values generated
       icom2: 17329 missing values generated
       iprv2: 8674 missing values generated
       irie2: 8674 missing values generated
       iaus2: 8674 missing values generated
       ilib2: 8674 missing values generated
       ison2: 17329 missing values generated

. 
. egen    pinc_gross_ttl = rowtotal($pinc_components) , missing
(9,332 missing values generated)

. replace pinc_gross_ttl = pinc_gross_ttl / 12
(590,316 real changes made)

. 
. * Monthly gross household income
. egen    hinc_gross_ttl = total(pinc_gross_ttl), by(hh_id wave) mis
> sing
(9,332 missing values generated)

. 
. * Monthly personal income as a proportion of monthly household inc
> ome
. gen prop_personal_hinc = pinc_gross_ttl / hinc_gross
(30,179 missing values generated)

. 
. * Monthly Household Net Income
. gen hinc = hlc0005_h if hlc0005_h >= 0 & !missing(hlc0005_h)
(34,358 missing values generated)

. 
. * Proportion household income from rents
. mvdecode renty opery lossr i11102 i11109, mv(-1 -2 -3 = . \ -5 = .
> a\ -8 = .b)
       renty: 8629 missing values generated
       opery: 8629 missing values generated
       lossr: 8629 missing values generated
      i11102: 17284 missing values generated
      i11109: 17284 missing values generated

. tempvar net_rental_income 

. gen `net_rental_income' = (renty - opery - lossr)
(9,332 missing values generated)

. gen prop_rentinc_hinc = `net_rental_income' / i11102
(18,456 missing values generated)

. 
. * Equivalized HH Income
. gen hinc_eq = hinc / sqrt(hh_mmb)
(34,358 missing values generated)

. gen log_hinc_eq = log(hinc_eq + 1)
(34,358 missing values generated)

. 
. *** Labor Market Participation & Status
. * Indicator for current labor market participation
. la def lm 1 "Active" 2 "Unemployed" 3 "In Education" ///
>                   4 " (Mostly) inactive" 5 "Pensioners"

. recode pglfs (11 12 4 = 1) (6 = 2) (3 5  = 3) (1 8 9 10 = 4) (2 = 
> 5), ///
>              copy gen(lm_part)
(656,885 differences between pglfs and lm_part)

. replace lm_part = . if lm_part <= 0
(4 real changes made, 4 to missing)

. la val lm_part lm

. 
. * Number/proportion economically active HH membership
. tempvar active

. recode lm_part (2 3 4 5= 0), gen(`active')
(268,951 differences between lm_part and __000001)

. egen hh_num_ecact  = total(`active'), by(hh_id wave)

. gen  hh_prop_ecact = hh_num_ecact / hh_mmb
(703 missing values generated)

. 
. * Current unemployment
. gen unemp00 = (lm_part == 2) if !missing(lm_part)
(49 missing values generated)

. 
. 
. *** Atypical employment
. * Temporary Employment
. gen     temp = (plb0037_v1 == 1)

. replace temp = . if plb0037_v1 < 0 /* missing / invalid */
(619,767 real changes made, 619,767 to missing)

. replace temp = 1 if plb0037_v2 == 1 & syear > 1999 & syear < 2006
(9,101 real changes made)

. replace temp = 0 if plb0037_v2 == 2 & syear > 1999 & syear < 2006
(56,070 real changes made)

. replace temp = 1 if plb0037_v3 == 2 & syear > 2005
(29,124 real changes made)

. replace temp = 0 if plb0037_v3 == 1 & syear > 2005
(143,807 real changes made)

. replace temp = 0 if missing(temp) & plb0057_h > 0 & plb0057_h < 6
(21,279 real changes made)

. 
. /*
> sort id year
> bys id: replace temp = temp[_n-1] if missing(temp)
> */
. 
. * Involuntary Parttime
. gen     deshour = .
(682,447 missing values generated)

. replace deshour = plb0241_v1
(682,447 real changes made)

. replace deshour = plb0241_v2 if syear > 1999 & syear != 2016
(452,105 real changes made)

. replace deshour = deshour/10 if syear > 1999 & syear != 2016
(451,414 real changes made)

. replace deshour = . if deshour<0
(335,498 real changes made, 335,498 to missing)

. 
. /*
> sort id year
> bys id: replace deshour = deshour[_n-1] if missing(deshour)
> */
. 
. gen     realhour = .
(682,447 missing values generated)

. replace realhour = plb0176_v1
(682,447 real changes made)

. replace realhour = plb0176_v3 if syear > 1989
(618,172 real changes made)

. replace realhour = realhour/10 if syear > 1989
(618,165 real changes made)

. replace realhour=. if realhour < 0
(351,773 real changes made, 351,773 to missing)

. 
. /*
> sort id year
> bys id: replace realhour = realhour[_n-1] if missing(realhour)
> */
. 
. gen     diffhour = deshour - realhour
(390,512 missing values generated)

. gen     involpart = diffhour >= 5 & deshour > 35

. replace involpart = . if missing(diffhour)
(390,512 real changes made, 390,512 to missing)

. drop    deshour realhour diffhour

. 
. * Zeit-/Leiharbeit (from 2001)
. gen     zlwork = plb0041 == 1

. replace zlwork = . if !inrange(plb0041, 1, 2)
(428,912 real changes made, 428,912 to missing)

. 
. /*
> sort id year
> bys id: replace zlwork = zlwork[_n-1] if missing(zlwork)
> */
. 
. * Atypical employment (any form)
. gen     aemp = temp == 1 | involpart == 1 | zlwork == 1 

. replace aemp = . if missing(temp) & missing(involpart) & missing(z
> lwork) 
(307,033 real changes made, 307,033 to missing)

. 
. * Update labormarket status accordingly:        
. replace lm_part = 6 if aemp == 1        
(76,278 real changes made)

. drop aemp

. 
. la def lm 1 "Active" 2 "Unemployed" 3 "In Education" ///
>                   4 " (Mostly) inactive" 5 "Pensioners" ///
>                   6 "Active, Atypical", replace

. la val lm_part lm

.         
.                                         
. ******************************************************************
> ******************************************************************
> ********
. * OESCH CLASS SCHEMA
. * Create 16-Class schema, 8-Class schema, 5-Class schema, 4-class 
> schema
. * Data: German Socio-Economic Panel (SOEP), version: CNEF equivale
> nt file
. * July 2015
. * Oliver Lipps, Swiss Centre of Expertise in the Social Sciences (
> FORS), Lausanne
. ******************************************************************
> ******************************************************************
> *********
. 
. **** References:
. **** Oesch, D. (2006a) "Coming to grips with a changing class stru
> cture" International Sociology 21 (2): 263-288.
. **** Oesch, D. (2006b) "Redrawing the Class Map. Stratification an
> d Institutions in Britain, Germany, Sweden and Switzerland", Basin
> gstoke: Palgrave Macmillan.
. **** A few minor changes were made with respect to the procedure d
> escribed in these two sources (decisions taken by Oesch and Tawfik
>  in 2013)
. 
. **** 16-Class schema constructed
.   *1 Large employers
.   *2 Self-employed professionals
.   *3 Small business owners with employees
.   *4 Small business owners without employees
.   *5 Technical experts
.   *6 Technicians
.   *7 Skilled craft and production workers
.   *8 Low-skilled production workers
.   *9 Higher-grade managers and administrators
.   *10 Lower-grade managers and administrators
.   *11 Skilled clerks
.   *12 Unskilled clerks
.   *13 Socio-cultural professionals
.   *14 Socio-cultural semi-professionals
.   *15 Skilled service
.   *16 Low-skilled service
. 
. **** 8-Class schema constructed
.   *1 Self-employed professionals and large employers
.   *2 Small business owners
.   *3 Technical (semi-)professionals
.   *4 Production workers
.   *5 (Associate) managers
.   *6 Clerks
.   *7 Socio-cultural (semi-)professionals
.   *8 Service workers
. 
. **** 5-Class schema constructed
.   *1 Higher-grade service class
.   *2 Lower-grade service class
.   *3 Small business owners
.   *4 Skilled workers
.   *5 Low-skilled workers
. 
. **** 4-Class schema constructed
.   *1 Upper-middle class
.   *2 Lower-middle class
.   *3 Skilled workers
.   *4 Low-skilled workers
.   
. **** Variables used to construct Oesch class schema: iscoco, emplr
> el, emplno, iscocop, emprelp, emplnop
. 
. ******************************************************************
> **********************
. * Respondent's Oesch class position
. * Recode and create variables used to construct class variable for
>  respondents
. * Variables used to construct class variable for respondents: isco
> co, emplrel, emplno
. ******************************************************************
> **********************
. /*
> *** define macro LONG_FILES which is a variable for the directory 
> which include the SOEP person long file pl,
> *** and the SOEP person equivalent file pequiv. For example if the
> se files are in d:\my_SOEP_data
> *** then write the command line: �global LONG_FILES d:\my_SOEP_dat
> a\�
> 
> use pid syear e11105 using $longpath\pequiv, clear // key variable
>  is e11105 (isco-88 at 4-digit level)
> rename e11105 isco_mainjob // Current occupation of respondent, co
> ded with isco88 4-digit
> merge 1:1 pid syear using $longpath\pl, keepusing(plb0058 plb0057-
> plb0065) ///
>  keep(match) nogen // only people who answered the survey
> */
. 
. **** Recode occupation variable (isco88 com 4-digit) for responden
> ts
. clonevar isco_mainjob = pgisco88
(45 missing values generated)

. tab isco_mainjob

   aktueller Beruf [pber] (ISCO-88 COM, |
                             4-Steller) |      Freq.     Percent    
>     Cum.
----------------------------------------+---------------------------
> --------
[-8] nicht im Frageprogramm des Jahres  |      4,055        0.59    
>     0.59
                   [-2] trifft nicht zu |    297,477       43.59    
>    44.19
                      [-1] keine Angabe |      2,137        0.31    
>    44.50
                         [100] Soldaten |      1,611        0.24    
>    44.74
[1110] Angehoerige gesetzgebender Koerp |        143        0.02    
>    44.76
[1140] Leitende Bedienstete von Interes |         65        0.01    
>    44.77
[1141] Leitende Bedienstete politischer |          9        0.00    
>    44.77
[1142] Leitende Bedienstete von Arbeitg |        272        0.04    
>    44.81
[1143] Leitende Bedienstete humanitaere |          4        0.00    
>    44.81
[1200] Geschaeftsleiter und Geschaeftsb |      1,345        0.20    
>    45.01
[1210] Direktoren und Hauptgeschaeftsfu |      2,993        0.44    
>    45.44
[1221] Produktions- und Operationsleite |         21        0.00    
>    45.45
[1222] Produktions- und Operationsleite |      1,709        0.25    
>    45.70
[1225] Produktions- und Operationsleite |        235        0.03    
>    45.73
[1226] Produktions- und Operationsleite |        112        0.02    
>    45.75
[1227] Produktions- und Operationsleite |        796        0.12    
>    45.87
[1229] Produktions- und Operationsleite |      1,016        0.15    
>    46.01
[1231] Finanzdirektoren und Verwaltungs |        393        0.06    
>    46.07
[1232] Personalleiter und Sozialdirekto |        697        0.10    
>    46.17
      [1233] Verkaufs- und Absatzleiter |      2,746        0.40    
>    46.58
[1234] Werbeleiter und Leiter der Oeffe |        114        0.02    
>    46.59
[1235] Leiter des Einkaufs und der Mate |        206        0.03    
>    46.62
                  [1236] Leiter der EDV |        469        0.07    
>    46.69
[1239] Sonstige Fachbereichsleiter, and |        161        0.02    
>    46.72
      [1300] Leiter kleiner Unternehmen |      1,568        0.23    
>    46.95
[1311] Leiter kleiner Unternehmen in de |         35        0.01    
>    46.95
[1312] Leiter kleiner Unternehmen im ve |         83        0.01    
>    46.96
[1313] Leiter kleiner Unternehmen im Ba |        309        0.05    
>    47.01
[1314] Leiter kleiner Unternehmen im Gr |      3,666        0.54    
>    47.54
[1315] Leiter kleiner Unternehmen von R |      1,835        0.27    
>    47.81
[1316] Leiter kleiner Unternehmen im Tr |        403        0.06    
>    47.87
[1317] Leiter von kleinen gewerblichen  |        114        0.02    
>    47.89
[1318] Leiter von kleinen Koerperpflege |         20        0.00    
>    47.89
[1319] Leiter kleiner Unternehmen, ande |        376        0.06    
>    47.95
         [2111] Physiker und Astronomen |        187        0.03    
>    47.97
                    [2112] Meteorologen |         16        0.00    
>    47.98
                        [2113] Chemiker |        345        0.05    
>    48.03
        [2114] Geologen und Geophysiker |         82        0.01    
>    48.04
[2121] Mathematiker und verwandte Wisse |         62        0.01    
>    48.05
                     [2122] Statistiker |         47        0.01    
>    48.06
[2131] Systemplaner, Systemanalytiker u |      1,784        0.26    
>    48.32
[2139] Informatiker, anderweitig nicht  |      2,358        0.35    
>    48.66
[2141] Architekten, Raum- und Verkehrsp |      1,538        0.23    
>    48.89
                   [2142] Bauingenieure |      2,250        0.33    
>    49.22
               [2143] Elektroingenieure |      1,399        0.21    
>    49.42
[2144] Elektronik- und Fernmeldeingenie |        981        0.14    
>    49.57
          [2145] Maschinenbauingenieure |      2,684        0.39    
>    49.96
                [2146] Chemieingenieure |        559        0.08    
>    50.04
[2147] Bergbauingenieure, Metallurgen u |        160        0.02    
>    50.07
[2148] Kartographen und Vermessungsinge |        164        0.02    
>    50.09
[2149] Architekten, Ingenieure und verw |      4,112        0.60    
>    50.69
[2211] Biologen, Botaniker, Zoologen un |        201        0.03    
>    50.72
[2212] Pharmakologen, Pathologen und ve |         26        0.00    
>    50.73
[2213] Agrar- und verwandte Wissenschaf |        336        0.05    
>    50.77
                          [2221] Aerzte |      3,117        0.46    
>    51.23
                      [2222] Zahnaerzte |        672        0.10    
>    51.33
                      [2223] Tieraerzte |        174        0.03    
>    51.36
                       [2224] Apotheker |        558        0.08    
>    51.44
[2310] Universitaets- und Hochschullehr |      1,942        0.28    
>    51.72
    [2320] Lehrer des Sekundarbereiches |      9,384        1.38    
>    53.10
[2331] Wissenschaftliche Lehrer des Pri |      1,466        0.21    
>    53.31
[2340] Wissenschaftliche Sonderschulleh |        704        0.10    
>    53.41
[2359] Sonstige wissenschaftliche Lehrk |      1,661        0.24    
>    53.66
[2400] Sonstige Wissenschaftler und ver |        244        0.04    
>    53.69
[2411] Buchpruefer, Revisoren, Steuerbe |        859        0.13    
>    53.82
[2412] Personalfachleute, Berufsberater |        444        0.07    
>    53.88
[2419] Unternehmensberatungs- und Organ |      4,231        0.62    
>    54.50
                        [2421] Anwaelte |      1,500        0.22    
>    54.72
                         [2422] Richter |        271        0.04    
>    54.76
[2429] Juristen, anderweitig nicht gena |        932        0.14    
>    54.90
[2431] Archiv- und Museumswissenschaftl |        172        0.03    
>    54.93
[2432] Bibliotheks-, Dokumentations- un |        246        0.04    
>    54.96
      [2441] Wirtschaftswissenschaftler |        759        0.11    
>    55.07
[2442] Soziologen, Anthropologen und ve |        164        0.02    
>    55.10
[2443] Philosophen, Historiker und Poli |        153        0.02    
>    55.12
[2444] Philologen, Uebersetzer und Dolm |        319        0.05    
>    55.17
                     [2445] Psychologen |        621        0.09    
>    55.26
                  [2446] Sozialarbeiter |      3,777        0.55    
>    55.81
[2451] Autoren, Journalisten und andere |      1,562        0.23    
>    56.04
[2452] Bildhauer, Maler und verwandte K |        226        0.03    
>    56.07
[2453] Komponisten, Musiker und Saenger |        553        0.08    
>    56.15
       [2454] Choreographen und Taenzer |         19        0.00    
>    56.16
[2455] Film-, Buehnen- und sonstige Sch |        259        0.04    
>    56.19
          [2460] Geistliche, Seelsorger |        569        0.08    
>    56.28
[2470] Wissenschaftliche Verwaltungsfac |      6,283        0.92    
>    57.20
     [3111] Chemo- und Physikotechniker |      1,330        0.19    
>    57.39
                    [3112] Bautechniker |        918        0.13    
>    57.53
                [3113] Elektrotechniker |        900        0.13    
>    57.66
[3114] Elektronik- und Fernmeldetechnik |        881        0.13    
>    57.79
           [3115] Maschinenbautechniker |      1,508        0.22    
>    58.01
      [3117] Bergbau-, Huettentechniker |        143        0.02    
>    58.03
             [3118] Technische Zeichner |      1,094        0.16    
>    58.19
[3119] Material- und ingenieurtechnisch |      2,982        0.44    
>    58.63
   [3120] Datenverarbeitungsfachkraefte |      1,041        0.15    
>    58.78
   [3121] Datenverarbeitungsassistenten |      2,314        0.34    
>    59.12
                  [3122] EDV-Operateure |        343        0.05    
>    59.17
[3131] Photographen und Bediener von Bi |        585        0.09    
>    59.26
[3132] Fernseh-, Rundfunk- und Fernmeld |         31        0.00    
>    59.26
  [3133] Bediener medizinischer Geraete |        319        0.05    
>    59.31
[3139] Bediener optischer und elektroni |         53        0.01    
>    59.32
             [3141] Schiffsmaschinisten |         48        0.01    
>    59.32
       [3142] Schiffsfuehrer und Lotsen |         72        0.01    
>    59.33
[3143] Flugzeugfuehrer und verwandte Be |         85        0.01    
>    59.35
              [3144] Flugverkehrslotsen |        238        0.03    
>    59.38
         [3145] Flugsicherungstechniker |         30        0.00    
>    59.38
[3151] Bau-, Brandschutz-, Brandinspekt |        156        0.02    
>    59.41
[3152] Gesundheits-, Umweltschutzinspek |      2,057        0.30    
>    59.71
                    [3211] Biotechniker |      1,043        0.15    
>    59.86
[3212] Agrar- und Forstwirtschaftstechn |        194        0.03    
>    59.89
[3213] Land- und forstwirtschaftliche B |         45        0.01    
>    59.90
[3222] Hygiene-, Gesundheitsaufsichts-  |        147        0.02    
>    59.92
[3223] Diaetassistenten und Ernaehrungs |         92        0.01    
>    59.93
                    [3224] Augenoptiker |        431        0.06    
>    59.99
[3226] Physiotherapeuten und verwandte  |      1,603        0.23    
>    60.23
     [3228] Pharmazeutische Assistenten |        669        0.10    
>    60.33
[3229] Medizinische Fachberufe (ohne Kr |      1,046        0.15    
>    60.48
[3231] Nicht-wissenschaftliche Krankens |      7,681        1.13    
>    61.61
[3232] Nicht-wissenschaftliche Hebammen |        233        0.03    
>    61.64
[3320] Nicht-wissenschaftliche Lehrkrae |      5,636        0.83    
>    62.47
[3330] Nicht-wissenschaftliche Sondersc |        597        0.09    
>    62.55
[3340] Sonstige nicht-wissenschaftliche |      1,730        0.25    
>    62.81
[3411] Effektenhaendler, -makler und Fi |        118        0.02    
>    62.83
          [3412] Versicherungsvertreter |        747        0.11    
>    62.93
                [3413] Immobilienmakler |      1,294        0.19    
>    63.12
  [3414] Reiseberater und -veranstalter |         59        0.01    
>    63.13
[3415] Technische und kaufmaennische Ha |      2,656        0.39    
>    63.52
                      [3416] Einkaeufer |        890        0.13    
>    63.65
      [3417] Schaetzer und Versteigerer |         43        0.01    
>    63.66
[3419] Finanz- und Verkaufsfachkraefte, |      7,875        1.15    
>    64.81
                   [3421] Handelsmakler |         39        0.01    
>    64.82
[3429] Vermittler gewerblicher Dienstle |      1,691        0.25    
>    65.07
[3431] Verwaltungssekretaere und verwan |      6,265        0.92    
>    65.98
[3432] Fachkraefte fuer Rechts- und ver |      4,370        0.64    
>    66.62
                      [3433] Buchhalter |      4,241        0.62    
>    67.25
[3442] Staatliche Steuer- und Abgabenbe |      1,025        0.15    
>    67.40
[3443] Staatliche Sozialverwaltungsbedi |      2,480        0.36    
>    67.76
[3449] Zoll-, Steuer- und verwandte Fac |      3,023        0.44    
>    68.20
 [3450] Polizeikommissare und Detektive |      1,497        0.22    
>    68.42
       [3460] Sozialpflegerische Berufe |      3,989        0.58    
>    69.01
[3471] Dekorateure und gewerbliche Desi |      1,246        0.18    
>    69.19
[3472] Rundfunk-, Fernsehsprecher und v |         17        0.00    
>    69.19
[3474] Clowns, Zauberer, Akrobaten und  |         38        0.01    
>    69.20
[3475] Athleten, Berufssportler und ver |        448        0.07    
>    69.26
[3480] Ordensbrueder/-schwestern und Se |        255        0.04    
>    69.30
[4111] Stenographen, Stenotypisten, Mas |        731        0.11    
>    69.41
[4112] Bediener von Textverarbeitungs-  |         14        0.00    
>    69.41
                   [4113] Datenerfasser |        292        0.04    
>    69.45
         [4114] Rechenmaschinenbediener |         14        0.00    
>    69.45
                  [4115] Sekretaerinnen |      3,600        0.53    
>    69.98
[4121] Rechnungswesen- und Buchhaltungs |      2,586        0.38    
>    70.36
[4122] Statistik- und Finanzangestellte |      6,197        0.91    
>    71.27
                  [4131] Lagerverwalter |      3,159        0.46    
>    71.73
     [4132] Material-, Fertigungsplaner |      2,415        0.35    
>    72.09
           [4133] Speditionsangestellte |      1,843        0.27    
>    72.36
[4141] Bibliotheks-, Dokumentations- un |        769        0.11    
>    72.47
    [4142] Postverteiler und -sortierer |      1,662        0.24    
>    72.71
[4143] Kodierer, Korrekturleser und ver |          9        0.00    
>    72.71
       [4190] Sonstige Bueroangestellte |     12,619        1.85    
>    74.56
  [4211] Kassierer und Kartenverkaeufer |      1,940        0.28    
>    74.85
[4212] Bank-, Post und andere Schalterb |      1,217        0.18    
>    75.03
        [4213] Buchmacher und Croupiers |         62        0.01    
>    75.03
[4215] Inkassobeauftragte und verwandte |         83        0.01    
>    75.05
           [4221] Reisebueroangestellte |        628        0.09    
>    75.14
[4222] Empfangsbuerokraefte und Auskunf |        915        0.13    
>    75.27
                    [4223] Telefonisten |      1,130        0.17    
>    75.44
     [5111] Reisebegleiter und Stewards |        133        0.02    
>    75.46
                       [5112] Schaffner |         92        0.01    
>    75.47
                    [5113] Reisefuehrer |        106        0.02    
>    75.49
[5121] Hauswirtschaftliche und verwandt |      1,836        0.27    
>    75.76
                          [5122] Koeche |      4,993        0.73    
>    76.49
           [5123] Kellner und Barkeeper |      3,005        0.44    
>    76.93
                  [5131] Kinderbetreuer |      1,847        0.27    
>    77.20
  [5132] Pflegekraefte in Institutionen |      7,995        1.17    
>    78.37
       [5133] Haus- und Familienpfleger |        158        0.02    
>    78.39
[5139] Pflege- und verwandte Berufe, an |        531        0.08    
>    78.47
[5141] Friseure, Kosmetiker und verwand |      2,924        0.43    
>    78.90
[5143] Leichenbestatter und Einbalsamie |         98        0.01    
>    78.91
[5149] Sonstige personenbezogene Dienst |        986        0.14    
>    79.06
                  [5161] Feuerwehrleute |        437        0.06    
>    79.12
                      [5162] Polizisten |      1,805        0.26    
>    79.39
              [5163] Gefaengnisaufseher |        333        0.05    
>    79.44
[5169] Sicherheitsbedienstete, anderwei |        884        0.13    
>    79.57
[5210] Mannequins/Dressmen und sonstige |         11        0.00    
>    79.57
[5220] Ladenverkaeufer, Verkaufs-, Mark |     14,777        2.17    
>    81.73
[6100] Fachkraefte in der Landwirtschaf |      1,902        0.28    
>    82.01
  [6111] Feldfrucht- und Gemueseanbauer |         60        0.01    
>    82.02
[6112] Gaertner, Saat- und Pflanzenzuec |      2,224        0.33    
>    82.35
[6121] Milchviehhalter und Nutztierzuec |        287        0.04    
>    82.39
               [6122] Gefluegelzuechter |         18        0.00    
>    82.39
[6129] Tierwirtschaftliche und verwandt |        161        0.02    
>    82.41
    [6141] Waldarbeiter und Holzfaeller |        387        0.06    
>    82.47
[6150] Fischer, Jaeger und Fallenstelle |         19        0.00    
>    82.47
      [6152] Binnen- und Kuestenfischer |          1        0.00    
>    82.47
        [6154] Jaeger und Fallensteller |          6        0.00    
>    82.47
      [7111] Bergleute und Steinbrecher |        388        0.06    
>    82.53
                   [7112] Sprengmeister |         13        0.00    
>    82.53
[7113] Steinspalter, -bearbeiter und St |        254        0.04    
>    82.57
          [7122] Maurer, Bausteinmetzen |      2,581        0.38    
>    82.95
[7123] Betonierer, Betonoberflaechenfer |        720        0.11    
>    83.05
           [7124] Zimmerer, Bautischler |      1,497        0.22    
>    83.27
[7129] Baukonstruktions- und verwandte  |        976        0.14    
>    83.42
                      [7131] Dachdecker |        689        0.10    
>    83.52
     [7132] Fussboden- und Fliesenleger |        831        0.12    
>    83.64
                     [7133] Stukkateure |        365        0.05    
>    83.69
                       [7134] Isolierer |        612        0.09    
>    83.78
                          [7135] Glaser |        182        0.03    
>    83.81
     [7136] Klempner, Rohrinstallateure |      4,472        0.66    
>    84.46
   [7137] Bau- und verwandte Elektriker |      4,091        0.60    
>    85.06
[7139] Ausbau- und verwandte Berufe, an |        284        0.04    
>    85.11
[7141] Maler, Tapezierer und verwandte  |      2,877        0.42    
>    85.53
[7143] Gebaeudereiniger und Schornstein |      1,214        0.18    
>    85.71
[7211] Former und Kernmacher (fuer Meta |         73        0.01    
>    85.72
   [7212] Schweisser und Brennschneider |      1,639        0.24    
>    85.96
              [7213] Blechkaltverformer |        965        0.14    
>    86.10
[7214] Baumetallverformer und Metallbau |      3,462        0.51    
>    86.60
[7215] Verspannungsmonteure und Seilspl |        110        0.02    
>    86.62
[7221] Grobschmiede, Hammerschmiede und |        103        0.02    
>    86.64
[7222] Werkzeugmacher und verwandte Ber |      1,293        0.19    
>    86.83
[7223] Werkzeugmaschineneinrichter und  |      3,181        0.47    
>    87.29
[7224] Metallschleifer, Metallpolierer  |        100        0.01    
>    87.31
[7231] Kraftfahrzeugmechaniker und -sch |      3,905        0.57    
>    87.88
[7232] Flugmotorenmechaniker und -schlo |        195        0.03    
>    87.91
[7233] Landmaschinen- oder Industriemas |      5,988        0.88    
>    88.78
[7241] Elektromechaniker, -monteure und |      3,705        0.54    
>    89.33
[7242] Elektronikmechaniker, -monteure  |        622        0.09    
>    89.42
[7244] Telefon- und Telegrapheninstalla |        364        0.05    
>    89.47
[7245] Elektrokabel-, Elektroleitungsmo |        117        0.02    
>    89.49
[7311] Praezisionsinstrumentenmacher un |      1,650        0.24    
>    89.73
[7312] Musikinstrumentenmacher und -sti |        123        0.02    
>    89.75
[7313] Schmuckwarenhersteller und Edelm |        137        0.02    
>    89.77
    [7321] Toepfer und verwandte Berufe |        241        0.04    
>    89.80
[7322] Glasmacher, -schneider, -schleif |        170        0.02    
>    89.83
        [7323] Glasgraveure und -aetzer |          4        0.00    
>    89.83
[7324] Glas-, Keram- und verwandte Deko |        116        0.02    
>    89.85
[7331] Kunsthandwerker fuer Holz und ve |         44        0.01    
>    89.85
[7332] Kunsthandwerker fuer Textilien,  |         33        0.00    
>    89.86
[7341] Schriftsetzer und verwandte Beru |      1,081        0.16    
>    90.02
[7342] Stereotypeure und Galvanoplastik |          2        0.00    
>    90.02
  [7343] Klischeehersteller und -aetzer |        271        0.04    
>    90.06
                  [7344] Fotolaboranten |         80        0.01    
>    90.07
 [7345] Buchbinder und verwandte Berufe |        224        0.03    
>    90.10
[7346] Sieb-, Druckstock- und Textildru |        107        0.02    
>    90.12
[7411] Fleischer, Fischhaendler und ver |        840        0.12    
>    90.24
[7412] Baecker, Konditoren und Suesswar |      1,567        0.23    
>    90.47
         [7413] Molkereiwarenhersteller |         54        0.01    
>    90.48
[7416] Tabakaufbereiter und Tabakwarenh |         24        0.00    
>    90.48
  [7421] Holztrockner und -konservierer |          2        0.00    
>    90.48
[7422] Moebeltischler und verwandte Ber |      2,646        0.39    
>    90.87
[7423] Holzbearbeitungsmaschineneinrich |        525        0.08    
>    90.95
[7424] Korbflechter, Buerstenmacher und |         32        0.00    
>    90.95
                [7431] Spinnvorbereiter |         70        0.01    
>    90.96
[7432] Weber, Stricker, Wirker und verw |        149        0.02    
>    90.98
[7433] Herren-, Damenschneider und Hutm |        602        0.09    
>    91.07
 [7434] Kuerschner und verwandte Berufe |          6        0.00    
>    91.07
[7435] Schnittmustermacher und Zuschnei |         15        0.00    
>    91.07
[7436] Naeher, Sticker und verwandte Be |        934        0.14    
>    91.21
  [7437] Polsterer und verwandte Berufe |        380        0.06    
>    91.27
[7441] Rauchwarenzurichter, Gerber und  |         13        0.00    
>    91.27
[7442] Schuhmacher und verwandte Berufe |        464        0.07    
>    91.34
[8111] Bediener von bergbaulichen Masch |         19        0.00    
>    91.34
[8112] Bediener von Erz- und Gesteinsau |         13        0.00    
>    91.34
 [8113] Tiefbohrer und verwandte Berufe |         47        0.01    
>    91.35
[8121] Ofenbediener (Erzschmelzen, Meta |        214        0.03    
>    91.38
[8122] Metallschmelzer, Metallgiesser u |        633        0.09    
>    91.47
  [8123] Metallhaerter, Metallvergueter |         67        0.01    
>    91.48
       [8124] Metallzieher, Presszieher |         48        0.01    
>    91.49
[8131] Glasschmelz-, Kerambrennofenbedi |         17        0.00    
>    91.49
[8139] Bediener von Anlagen zur Glas- u |         13        0.00    
>    91.49
[8141] Bediener von Holzaufbereitungsan |        259        0.04    
>    91.53
[8142] Bediener von Anlagen zur Papierb |         20        0.00    
>    91.53
[8143] Bediener von Papierherstellungsa |        352        0.05    
>    91.59
[8151] Bediener von Brechmaschinen, Mah |         10        0.00    
>    91.59
[8152] Bediener von Warmbehandlungsanla |         28        0.00    
>    91.59
[8159] Bediener chemischer Verfahrensan |      2,052        0.30    
>    91.89
[8161] Bediener von Energieerzeugungsan |        182        0.03    
>    91.92
[8162] Bediener von Dampfmaschinen und  |        185        0.03    
>    91.95
[8163] Bediener von Verbrennungs-, Wass |        419        0.06    
>    92.01
       [8211] Werkzeugmaschinenbediener |      3,657        0.54    
>    92.54
[8212] Bediener von Maschinen zur Herst |        141        0.02    
>    92.56
[8221] Bediener von Maschinen zur Herst |         77        0.01    
>    92.58
[8222] Bediener von Maschinen zur Herst |         12        0.00    
>    92.58
[8223] Bediener von Metalloberflaechenb |        370        0.05    
>    92.63
[8229] Maschinenbediener fuer chemische |        150        0.02    
>    92.65
[8231] Bediener von Maschinen zur Herst |        422        0.06    
>    92.72
[8232] Bediener von Maschinen zur Herst |      1,320        0.19    
>    92.91
[8240] Bediener von Holzbearbeitungsmas |        117        0.02    
>    92.93
      [8252] Buchbindemaschinenbediener |         47        0.01    
>    92.93
[8253] Bediener von Maschinen zur Herst |        288        0.04    
>    92.97
[8261] Bediener von Spinnvorbereitungs- |        220        0.03    
>    93.01
[8262] Bediener von Web-, Strick- und W |         31        0.00    
>    93.01
[8264] Bediener von Bleich-, Faerbe- un |      1,003        0.15    
>    93.16
[8265] Bediener von Pelz- und Ledervorb |          3        0.00    
>    93.16
[8266] Maschinenbediener fuer die Herst |         53        0.01    
>    93.17
[8269] Maschinenbediener fuer Textil-,  |         39        0.01    
>    93.17
[8271] Bediener von Fleisch- und Fischv |        174        0.03    
>    93.20
[8272] Bediener von Milchverarbeitungsm |        256        0.04    
>    93.24
[8273] Bediener von Getreide- und Gewue |         27        0.00    
>    93.24
[8274] Bediener von Maschinen zur Herst |        166        0.02    
>    93.26
[8275] Bediener von Obst-, Gemuese- und |        619        0.09    
>    93.35
[8276] Bediener von Zuckerherstellungsm |         73        0.01    
>    93.37
[8277] Bediener von Tee-, Kaffee- und K |         23        0.00    
>    93.37
[8278] Brauer, Bediener von Wein- und s |        223        0.03    
>    93.40
[8279] Bediener von Tabakaufbereitungs- |         25        0.00    
>    93.40
                       [8280] Montierer |          2        0.00    
>    93.41
[8281] Montierer (von mechanischen Baut |         52        0.01    
>    93.41
[8282] Montierer (von elektrischen Einr |        483        0.07    
>    93.48
[8284] Montierer von Metall-, Gummi- un |        460        0.07    
>    93.55
[8290] Sonstige Maschinenbediener, ande |      1,936        0.28    
>    93.83
                [8311] Lokomotivfuehrer |        317        0.05    
>    93.88
[8312] Eisenbahnbremser, Stellwerksbedi |        536        0.08    
>    93.96
[8322] Personenkraftwagen-, Taxi- und K |      4,179        0.61    
>    94.57
[8323] Busfahrer und Strassenbahnfuehre |      1,159        0.17    
>    94.74
  [8324] Fahrer schwerer Lastkraftwagen |      3,916        0.57    
>    95.32
[8331] Fuehrer von motorisierten land-  |         59        0.01    
>    95.32
[8332] Fuehrer von Erdbewegungs- und ve |      1,690        0.25    
>    95.57
[8333] Kranfuehrer, Aufzugsmaschinisten |        383        0.06    
>    95.63
                [8334] Hubkarrenfuehrer |      1,061        0.16    
>    95.78
[8340] Deckspersonal auf Schiffen und v |         67        0.01    
>    95.79
                [9111] Strassenhaendler |         28        0.00    
>    95.80
[9131] Haushaltshilfen und Reinigungspe |      1,520        0.22    
>    96.02
[9132] Hilfskraefte und Reinigungsperso |      8,866        1.30    
>    97.32
[9141] Hausmeister, Hauswarte und verwa |      3,156        0.46    
>    97.78
[9142] Fahrzeugreiniger, Fensterputzer  |        386        0.06    
>    97.84
[9151] Boten, Paket-, Gepaecktraeger un |        988        0.14    
>    97.98
[9152] Pfoertner, Wachpersonal und verw |        863        0.13    
>    98.11
[9153] Automatenkassierer, Zaehlerables |         30        0.00    
>    98.11
                    [9161] Muellsammler |        312        0.05    
>    98.16
[9162] Strassenkehrer und verwandte Ber |         13        0.00    
>    98.16
[9211] Landwirtschaftliche Hilfsarbeite |      1,078        0.16    
>    98.32
[9212] Forstwirtschaftliche Hilfsarbeit |          9        0.00    
>    98.32
[9311] Hilfsarbeiter im Bergbau und Ste |         49        0.01    
>    98.33
[9312] Bau- und Instandhaltungshilfsarb |         32        0.00    
>    98.33
     [9313] Bauhilfsarbeiter (Gebaeude) |      1,202        0.18    
>    98.51
  [9320] Hilfsarbeiter in der Fertigung |      6,855        1.00    
>    99.51
   [9330] Transport- und Frachtarbeiter |      3,318        0.49    
>   100.00
----------------------------------------+---------------------------
> --------
                                  Total |    682,402      100.00

. recode isco_mainjob (66666 77777 88888 99999=-9), copyrest
(0 changes made to isco_mainjob)

. label variable isco_mainjob "Current occupation of respondent - is
> co88 4-digit"

. tab isco_mainjob

     Current occupation of respondent - |
                         isco88 4-digit |      Freq.     Percent    
>     Cum.
----------------------------------------+---------------------------
> --------
[-8] nicht im Frageprogramm des Jahres  |      4,055        0.59    
>     0.59
                   [-2] trifft nicht zu |    297,477       43.59    
>    44.19
                      [-1] keine Angabe |      2,137        0.31    
>    44.50
                         [100] Soldaten |      1,611        0.24    
>    44.74
[1110] Angehoerige gesetzgebender Koerp |        143        0.02    
>    44.76
[1140] Leitende Bedienstete von Interes |         65        0.01    
>    44.77
[1141] Leitende Bedienstete politischer |          9        0.00    
>    44.77
[1142] Leitende Bedienstete von Arbeitg |        272        0.04    
>    44.81
[1143] Leitende Bedienstete humanitaere |          4        0.00    
>    44.81
[1200] Geschaeftsleiter und Geschaeftsb |      1,345        0.20    
>    45.01
[1210] Direktoren und Hauptgeschaeftsfu |      2,993        0.44    
>    45.44
[1221] Produktions- und Operationsleite |         21        0.00    
>    45.45
[1222] Produktions- und Operationsleite |      1,709        0.25    
>    45.70
[1225] Produktions- und Operationsleite |        235        0.03    
>    45.73
[1226] Produktions- und Operationsleite |        112        0.02    
>    45.75
[1227] Produktions- und Operationsleite |        796        0.12    
>    45.87
[1229] Produktions- und Operationsleite |      1,016        0.15    
>    46.01
[1231] Finanzdirektoren und Verwaltungs |        393        0.06    
>    46.07
[1232] Personalleiter und Sozialdirekto |        697        0.10    
>    46.17
      [1233] Verkaufs- und Absatzleiter |      2,746        0.40    
>    46.58
[1234] Werbeleiter und Leiter der Oeffe |        114        0.02    
>    46.59
[1235] Leiter des Einkaufs und der Mate |        206        0.03    
>    46.62
                  [1236] Leiter der EDV |        469        0.07    
>    46.69
[1239] Sonstige Fachbereichsleiter, and |        161        0.02    
>    46.72
      [1300] Leiter kleiner Unternehmen |      1,568        0.23    
>    46.95
[1311] Leiter kleiner Unternehmen in de |         35        0.01    
>    46.95
[1312] Leiter kleiner Unternehmen im ve |         83        0.01    
>    46.96
[1313] Leiter kleiner Unternehmen im Ba |        309        0.05    
>    47.01
[1314] Leiter kleiner Unternehmen im Gr |      3,666        0.54    
>    47.54
[1315] Leiter kleiner Unternehmen von R |      1,835        0.27    
>    47.81
[1316] Leiter kleiner Unternehmen im Tr |        403        0.06    
>    47.87
[1317] Leiter von kleinen gewerblichen  |        114        0.02    
>    47.89
[1318] Leiter von kleinen Koerperpflege |         20        0.00    
>    47.89
[1319] Leiter kleiner Unternehmen, ande |        376        0.06    
>    47.95
         [2111] Physiker und Astronomen |        187        0.03    
>    47.97
                    [2112] Meteorologen |         16        0.00    
>    47.98
                        [2113] Chemiker |        345        0.05    
>    48.03
        [2114] Geologen und Geophysiker |         82        0.01    
>    48.04
[2121] Mathematiker und verwandte Wisse |         62        0.01    
>    48.05
                     [2122] Statistiker |         47        0.01    
>    48.06
[2131] Systemplaner, Systemanalytiker u |      1,784        0.26    
>    48.32
[2139] Informatiker, anderweitig nicht  |      2,358        0.35    
>    48.66
[2141] Architekten, Raum- und Verkehrsp |      1,538        0.23    
>    48.89
                   [2142] Bauingenieure |      2,250        0.33    
>    49.22
               [2143] Elektroingenieure |      1,399        0.21    
>    49.42
[2144] Elektronik- und Fernmeldeingenie |        981        0.14    
>    49.57
          [2145] Maschinenbauingenieure |      2,684        0.39    
>    49.96
                [2146] Chemieingenieure |        559        0.08    
>    50.04
[2147] Bergbauingenieure, Metallurgen u |        160        0.02    
>    50.07
[2148] Kartographen und Vermessungsinge |        164        0.02    
>    50.09
[2149] Architekten, Ingenieure und verw |      4,112        0.60    
>    50.69
[2211] Biologen, Botaniker, Zoologen un |        201        0.03    
>    50.72
[2212] Pharmakologen, Pathologen und ve |         26        0.00    
>    50.73
[2213] Agrar- und verwandte Wissenschaf |        336        0.05    
>    50.77
                          [2221] Aerzte |      3,117        0.46    
>    51.23
                      [2222] Zahnaerzte |        672        0.10    
>    51.33
                      [2223] Tieraerzte |        174        0.03    
>    51.36
                       [2224] Apotheker |        558        0.08    
>    51.44
[2310] Universitaets- und Hochschullehr |      1,942        0.28    
>    51.72
    [2320] Lehrer des Sekundarbereiches |      9,384        1.38    
>    53.10
[2331] Wissenschaftliche Lehrer des Pri |      1,466        0.21    
>    53.31
[2340] Wissenschaftliche Sonderschulleh |        704        0.10    
>    53.41
[2359] Sonstige wissenschaftliche Lehrk |      1,661        0.24    
>    53.66
[2400] Sonstige Wissenschaftler und ver |        244        0.04    
>    53.69
[2411] Buchpruefer, Revisoren, Steuerbe |        859        0.13    
>    53.82
[2412] Personalfachleute, Berufsberater |        444        0.07    
>    53.88
[2419] Unternehmensberatungs- und Organ |      4,231        0.62    
>    54.50
                        [2421] Anwaelte |      1,500        0.22    
>    54.72
                         [2422] Richter |        271        0.04    
>    54.76
[2429] Juristen, anderweitig nicht gena |        932        0.14    
>    54.90
[2431] Archiv- und Museumswissenschaftl |        172        0.03    
>    54.93
[2432] Bibliotheks-, Dokumentations- un |        246        0.04    
>    54.96
      [2441] Wirtschaftswissenschaftler |        759        0.11    
>    55.07
[2442] Soziologen, Anthropologen und ve |        164        0.02    
>    55.10
[2443] Philosophen, Historiker und Poli |        153        0.02    
>    55.12
[2444] Philologen, Uebersetzer und Dolm |        319        0.05    
>    55.17
                     [2445] Psychologen |        621        0.09    
>    55.26
                  [2446] Sozialarbeiter |      3,777        0.55    
>    55.81
[2451] Autoren, Journalisten und andere |      1,562        0.23    
>    56.04
[2452] Bildhauer, Maler und verwandte K |        226        0.03    
>    56.07
[2453] Komponisten, Musiker und Saenger |        553        0.08    
>    56.15
       [2454] Choreographen und Taenzer |         19        0.00    
>    56.16
[2455] Film-, Buehnen- und sonstige Sch |        259        0.04    
>    56.19
          [2460] Geistliche, Seelsorger |        569        0.08    
>    56.28
[2470] Wissenschaftliche Verwaltungsfac |      6,283        0.92    
>    57.20
     [3111] Chemo- und Physikotechniker |      1,330        0.19    
>    57.39
                    [3112] Bautechniker |        918        0.13    
>    57.53
                [3113] Elektrotechniker |        900        0.13    
>    57.66
[3114] Elektronik- und Fernmeldetechnik |        881        0.13    
>    57.79
           [3115] Maschinenbautechniker |      1,508        0.22    
>    58.01
      [3117] Bergbau-, Huettentechniker |        143        0.02    
>    58.03
             [3118] Technische Zeichner |      1,094        0.16    
>    58.19
[3119] Material- und ingenieurtechnisch |      2,982        0.44    
>    58.63
   [3120] Datenverarbeitungsfachkraefte |      1,041        0.15    
>    58.78
   [3121] Datenverarbeitungsassistenten |      2,314        0.34    
>    59.12
                  [3122] EDV-Operateure |        343        0.05    
>    59.17
[3131] Photographen und Bediener von Bi |        585        0.09    
>    59.26
[3132] Fernseh-, Rundfunk- und Fernmeld |         31        0.00    
>    59.26
  [3133] Bediener medizinischer Geraete |        319        0.05    
>    59.31
[3139] Bediener optischer und elektroni |         53        0.01    
>    59.32
             [3141] Schiffsmaschinisten |         48        0.01    
>    59.32
       [3142] Schiffsfuehrer und Lotsen |         72        0.01    
>    59.33
[3143] Flugzeugfuehrer und verwandte Be |         85        0.01    
>    59.35
              [3144] Flugverkehrslotsen |        238        0.03    
>    59.38
         [3145] Flugsicherungstechniker |         30        0.00    
>    59.38
[3151] Bau-, Brandschutz-, Brandinspekt |        156        0.02    
>    59.41
[3152] Gesundheits-, Umweltschutzinspek |      2,057        0.30    
>    59.71
                    [3211] Biotechniker |      1,043        0.15    
>    59.86
[3212] Agrar- und Forstwirtschaftstechn |        194        0.03    
>    59.89
[3213] Land- und forstwirtschaftliche B |         45        0.01    
>    59.90
[3222] Hygiene-, Gesundheitsaufsichts-  |        147        0.02    
>    59.92
[3223] Diaetassistenten und Ernaehrungs |         92        0.01    
>    59.93
                    [3224] Augenoptiker |        431        0.06    
>    59.99
[3226] Physiotherapeuten und verwandte  |      1,603        0.23    
>    60.23
     [3228] Pharmazeutische Assistenten |        669        0.10    
>    60.33
[3229] Medizinische Fachberufe (ohne Kr |      1,046        0.15    
>    60.48
[3231] Nicht-wissenschaftliche Krankens |      7,681        1.13    
>    61.61
[3232] Nicht-wissenschaftliche Hebammen |        233        0.03    
>    61.64
[3320] Nicht-wissenschaftliche Lehrkrae |      5,636        0.83    
>    62.47
[3330] Nicht-wissenschaftliche Sondersc |        597        0.09    
>    62.55
[3340] Sonstige nicht-wissenschaftliche |      1,730        0.25    
>    62.81
[3411] Effektenhaendler, -makler und Fi |        118        0.02    
>    62.83
          [3412] Versicherungsvertreter |        747        0.11    
>    62.93
                [3413] Immobilienmakler |      1,294        0.19    
>    63.12
  [3414] Reiseberater und -veranstalter |         59        0.01    
>    63.13
[3415] Technische und kaufmaennische Ha |      2,656        0.39    
>    63.52
                      [3416] Einkaeufer |        890        0.13    
>    63.65
      [3417] Schaetzer und Versteigerer |         43        0.01    
>    63.66
[3419] Finanz- und Verkaufsfachkraefte, |      7,875        1.15    
>    64.81
                   [3421] Handelsmakler |         39        0.01    
>    64.82
[3429] Vermittler gewerblicher Dienstle |      1,691        0.25    
>    65.07
[3431] Verwaltungssekretaere und verwan |      6,265        0.92    
>    65.98
[3432] Fachkraefte fuer Rechts- und ver |      4,370        0.64    
>    66.62
                      [3433] Buchhalter |      4,241        0.62    
>    67.25
[3442] Staatliche Steuer- und Abgabenbe |      1,025        0.15    
>    67.40
[3443] Staatliche Sozialverwaltungsbedi |      2,480        0.36    
>    67.76
[3449] Zoll-, Steuer- und verwandte Fac |      3,023        0.44    
>    68.20
 [3450] Polizeikommissare und Detektive |      1,497        0.22    
>    68.42
       [3460] Sozialpflegerische Berufe |      3,989        0.58    
>    69.01
[3471] Dekorateure und gewerbliche Desi |      1,246        0.18    
>    69.19
[3472] Rundfunk-, Fernsehsprecher und v |         17        0.00    
>    69.19
[3474] Clowns, Zauberer, Akrobaten und  |         38        0.01    
>    69.20
[3475] Athleten, Berufssportler und ver |        448        0.07    
>    69.26
[3480] Ordensbrueder/-schwestern und Se |        255        0.04    
>    69.30
[4111] Stenographen, Stenotypisten, Mas |        731        0.11    
>    69.41
[4112] Bediener von Textverarbeitungs-  |         14        0.00    
>    69.41
                   [4113] Datenerfasser |        292        0.04    
>    69.45
         [4114] Rechenmaschinenbediener |         14        0.00    
>    69.45
                  [4115] Sekretaerinnen |      3,600        0.53    
>    69.98
[4121] Rechnungswesen- und Buchhaltungs |      2,586        0.38    
>    70.36
[4122] Statistik- und Finanzangestellte |      6,197        0.91    
>    71.27
                  [4131] Lagerverwalter |      3,159        0.46    
>    71.73
     [4132] Material-, Fertigungsplaner |      2,415        0.35    
>    72.09
           [4133] Speditionsangestellte |      1,843        0.27    
>    72.36
[4141] Bibliotheks-, Dokumentations- un |        769        0.11    
>    72.47
    [4142] Postverteiler und -sortierer |      1,662        0.24    
>    72.71
[4143] Kodierer, Korrekturleser und ver |          9        0.00    
>    72.71
       [4190] Sonstige Bueroangestellte |     12,619        1.85    
>    74.56
  [4211] Kassierer und Kartenverkaeufer |      1,940        0.28    
>    74.85
[4212] Bank-, Post und andere Schalterb |      1,217        0.18    
>    75.03
        [4213] Buchmacher und Croupiers |         62        0.01    
>    75.03
[4215] Inkassobeauftragte und verwandte |         83        0.01    
>    75.05
           [4221] Reisebueroangestellte |        628        0.09    
>    75.14
[4222] Empfangsbuerokraefte und Auskunf |        915        0.13    
>    75.27
                    [4223] Telefonisten |      1,130        0.17    
>    75.44
     [5111] Reisebegleiter und Stewards |        133        0.02    
>    75.46
                       [5112] Schaffner |         92        0.01    
>    75.47
                    [5113] Reisefuehrer |        106        0.02    
>    75.49
[5121] Hauswirtschaftliche und verwandt |      1,836        0.27    
>    75.76
                          [5122] Koeche |      4,993        0.73    
>    76.49
           [5123] Kellner und Barkeeper |      3,005        0.44    
>    76.93
                  [5131] Kinderbetreuer |      1,847        0.27    
>    77.20
  [5132] Pflegekraefte in Institutionen |      7,995        1.17    
>    78.37
       [5133] Haus- und Familienpfleger |        158        0.02    
>    78.39
[5139] Pflege- und verwandte Berufe, an |        531        0.08    
>    78.47
[5141] Friseure, Kosmetiker und verwand |      2,924        0.43    
>    78.90
[5143] Leichenbestatter und Einbalsamie |         98        0.01    
>    78.91
[5149] Sonstige personenbezogene Dienst |        986        0.14    
>    79.06
                  [5161] Feuerwehrleute |        437        0.06    
>    79.12
                      [5162] Polizisten |      1,805        0.26    
>    79.39
              [5163] Gefaengnisaufseher |        333        0.05    
>    79.44
[5169] Sicherheitsbedienstete, anderwei |        884        0.13    
>    79.57
[5210] Mannequins/Dressmen und sonstige |         11        0.00    
>    79.57
[5220] Ladenverkaeufer, Verkaufs-, Mark |     14,777        2.17    
>    81.73
[6100] Fachkraefte in der Landwirtschaf |      1,902        0.28    
>    82.01
  [6111] Feldfrucht- und Gemueseanbauer |         60        0.01    
>    82.02
[6112] Gaertner, Saat- und Pflanzenzuec |      2,224        0.33    
>    82.35
[6121] Milchviehhalter und Nutztierzuec |        287        0.04    
>    82.39
               [6122] Gefluegelzuechter |         18        0.00    
>    82.39
[6129] Tierwirtschaftliche und verwandt |        161        0.02    
>    82.41
    [6141] Waldarbeiter und Holzfaeller |        387        0.06    
>    82.47
[6150] Fischer, Jaeger und Fallenstelle |         19        0.00    
>    82.47
      [6152] Binnen- und Kuestenfischer |          1        0.00    
>    82.47
        [6154] Jaeger und Fallensteller |          6        0.00    
>    82.47
      [7111] Bergleute und Steinbrecher |        388        0.06    
>    82.53
                   [7112] Sprengmeister |         13        0.00    
>    82.53
[7113] Steinspalter, -bearbeiter und St |        254        0.04    
>    82.57
          [7122] Maurer, Bausteinmetzen |      2,581        0.38    
>    82.95
[7123] Betonierer, Betonoberflaechenfer |        720        0.11    
>    83.05
           [7124] Zimmerer, Bautischler |      1,497        0.22    
>    83.27
[7129] Baukonstruktions- und verwandte  |        976        0.14    
>    83.42
                      [7131] Dachdecker |        689        0.10    
>    83.52
     [7132] Fussboden- und Fliesenleger |        831        0.12    
>    83.64
                     [7133] Stukkateure |        365        0.05    
>    83.69
                       [7134] Isolierer |        612        0.09    
>    83.78
                          [7135] Glaser |        182        0.03    
>    83.81
     [7136] Klempner, Rohrinstallateure |      4,472        0.66    
>    84.46
   [7137] Bau- und verwandte Elektriker |      4,091        0.60    
>    85.06
[7139] Ausbau- und verwandte Berufe, an |        284        0.04    
>    85.11
[7141] Maler, Tapezierer und verwandte  |      2,877        0.42    
>    85.53
[7143] Gebaeudereiniger und Schornstein |      1,214        0.18    
>    85.71
[7211] Former und Kernmacher (fuer Meta |         73        0.01    
>    85.72
   [7212] Schweisser und Brennschneider |      1,639        0.24    
>    85.96
              [7213] Blechkaltverformer |        965        0.14    
>    86.10
[7214] Baumetallverformer und Metallbau |      3,462        0.51    
>    86.60
[7215] Verspannungsmonteure und Seilspl |        110        0.02    
>    86.62
[7221] Grobschmiede, Hammerschmiede und |        103        0.02    
>    86.64
[7222] Werkzeugmacher und verwandte Ber |      1,293        0.19    
>    86.83
[7223] Werkzeugmaschineneinrichter und  |      3,181        0.47    
>    87.29
[7224] Metallschleifer, Metallpolierer  |        100        0.01    
>    87.31
[7231] Kraftfahrzeugmechaniker und -sch |      3,905        0.57    
>    87.88
[7232] Flugmotorenmechaniker und -schlo |        195        0.03    
>    87.91
[7233] Landmaschinen- oder Industriemas |      5,988        0.88    
>    88.78
[7241] Elektromechaniker, -monteure und |      3,705        0.54    
>    89.33
[7242] Elektronikmechaniker, -monteure  |        622        0.09    
>    89.42
[7244] Telefon- und Telegrapheninstalla |        364        0.05    
>    89.47
[7245] Elektrokabel-, Elektroleitungsmo |        117        0.02    
>    89.49
[7311] Praezisionsinstrumentenmacher un |      1,650        0.24    
>    89.73
[7312] Musikinstrumentenmacher und -sti |        123        0.02    
>    89.75
[7313] Schmuckwarenhersteller und Edelm |        137        0.02    
>    89.77
    [7321] Toepfer und verwandte Berufe |        241        0.04    
>    89.80
[7322] Glasmacher, -schneider, -schleif |        170        0.02    
>    89.83
        [7323] Glasgraveure und -aetzer |          4        0.00    
>    89.83
[7324] Glas-, Keram- und verwandte Deko |        116        0.02    
>    89.85
[7331] Kunsthandwerker fuer Holz und ve |         44        0.01    
>    89.85
[7332] Kunsthandwerker fuer Textilien,  |         33        0.00    
>    89.86
[7341] Schriftsetzer und verwandte Beru |      1,081        0.16    
>    90.02
[7342] Stereotypeure und Galvanoplastik |          2        0.00    
>    90.02
  [7343] Klischeehersteller und -aetzer |        271        0.04    
>    90.06
                  [7344] Fotolaboranten |         80        0.01    
>    90.07
 [7345] Buchbinder und verwandte Berufe |        224        0.03    
>    90.10
[7346] Sieb-, Druckstock- und Textildru |        107        0.02    
>    90.12
[7411] Fleischer, Fischhaendler und ver |        840        0.12    
>    90.24
[7412] Baecker, Konditoren und Suesswar |      1,567        0.23    
>    90.47
         [7413] Molkereiwarenhersteller |         54        0.01    
>    90.48
[7416] Tabakaufbereiter und Tabakwarenh |         24        0.00    
>    90.48
  [7421] Holztrockner und -konservierer |          2        0.00    
>    90.48
[7422] Moebeltischler und verwandte Ber |      2,646        0.39    
>    90.87
[7423] Holzbearbeitungsmaschineneinrich |        525        0.08    
>    90.95
[7424] Korbflechter, Buerstenmacher und |         32        0.00    
>    90.95
                [7431] Spinnvorbereiter |         70        0.01    
>    90.96
[7432] Weber, Stricker, Wirker und verw |        149        0.02    
>    90.98
[7433] Herren-, Damenschneider und Hutm |        602        0.09    
>    91.07
 [7434] Kuerschner und verwandte Berufe |          6        0.00    
>    91.07
[7435] Schnittmustermacher und Zuschnei |         15        0.00    
>    91.07
[7436] Naeher, Sticker und verwandte Be |        934        0.14    
>    91.21
  [7437] Polsterer und verwandte Berufe |        380        0.06    
>    91.27
[7441] Rauchwarenzurichter, Gerber und  |         13        0.00    
>    91.27
[7442] Schuhmacher und verwandte Berufe |        464        0.07    
>    91.34
[8111] Bediener von bergbaulichen Masch |         19        0.00    
>    91.34
[8112] Bediener von Erz- und Gesteinsau |         13        0.00    
>    91.34
 [8113] Tiefbohrer und verwandte Berufe |         47        0.01    
>    91.35
[8121] Ofenbediener (Erzschmelzen, Meta |        214        0.03    
>    91.38
[8122] Metallschmelzer, Metallgiesser u |        633        0.09    
>    91.47
  [8123] Metallhaerter, Metallvergueter |         67        0.01    
>    91.48
       [8124] Metallzieher, Presszieher |         48        0.01    
>    91.49
[8131] Glasschmelz-, Kerambrennofenbedi |         17        0.00    
>    91.49
[8139] Bediener von Anlagen zur Glas- u |         13        0.00    
>    91.49
[8141] Bediener von Holzaufbereitungsan |        259        0.04    
>    91.53
[8142] Bediener von Anlagen zur Papierb |         20        0.00    
>    91.53
[8143] Bediener von Papierherstellungsa |        352        0.05    
>    91.59
[8151] Bediener von Brechmaschinen, Mah |         10        0.00    
>    91.59
[8152] Bediener von Warmbehandlungsanla |         28        0.00    
>    91.59
[8159] Bediener chemischer Verfahrensan |      2,052        0.30    
>    91.89
[8161] Bediener von Energieerzeugungsan |        182        0.03    
>    91.92
[8162] Bediener von Dampfmaschinen und  |        185        0.03    
>    91.95
[8163] Bediener von Verbrennungs-, Wass |        419        0.06    
>    92.01
       [8211] Werkzeugmaschinenbediener |      3,657        0.54    
>    92.54
[8212] Bediener von Maschinen zur Herst |        141        0.02    
>    92.56
[8221] Bediener von Maschinen zur Herst |         77        0.01    
>    92.58
[8222] Bediener von Maschinen zur Herst |         12        0.00    
>    92.58
[8223] Bediener von Metalloberflaechenb |        370        0.05    
>    92.63
[8229] Maschinenbediener fuer chemische |        150        0.02    
>    92.65
[8231] Bediener von Maschinen zur Herst |        422        0.06    
>    92.72
[8232] Bediener von Maschinen zur Herst |      1,320        0.19    
>    92.91
[8240] Bediener von Holzbearbeitungsmas |        117        0.02    
>    92.93
      [8252] Buchbindemaschinenbediener |         47        0.01    
>    92.93
[8253] Bediener von Maschinen zur Herst |        288        0.04    
>    92.97
[8261] Bediener von Spinnvorbereitungs- |        220        0.03    
>    93.01
[8262] Bediener von Web-, Strick- und W |         31        0.00    
>    93.01
[8264] Bediener von Bleich-, Faerbe- un |      1,003        0.15    
>    93.16
[8265] Bediener von Pelz- und Ledervorb |          3        0.00    
>    93.16
[8266] Maschinenbediener fuer die Herst |         53        0.01    
>    93.17
[8269] Maschinenbediener fuer Textil-,  |         39        0.01    
>    93.17
[8271] Bediener von Fleisch- und Fischv |        174        0.03    
>    93.20
[8272] Bediener von Milchverarbeitungsm |        256        0.04    
>    93.24
[8273] Bediener von Getreide- und Gewue |         27        0.00    
>    93.24
[8274] Bediener von Maschinen zur Herst |        166        0.02    
>    93.26
[8275] Bediener von Obst-, Gemuese- und |        619        0.09    
>    93.35
[8276] Bediener von Zuckerherstellungsm |         73        0.01    
>    93.37
[8277] Bediener von Tee-, Kaffee- und K |         23        0.00    
>    93.37
[8278] Brauer, Bediener von Wein- und s |        223        0.03    
>    93.40
[8279] Bediener von Tabakaufbereitungs- |         25        0.00    
>    93.40
                       [8280] Montierer |          2        0.00    
>    93.41
[8281] Montierer (von mechanischen Baut |         52        0.01    
>    93.41
[8282] Montierer (von elektrischen Einr |        483        0.07    
>    93.48
[8284] Montierer von Metall-, Gummi- un |        460        0.07    
>    93.55
[8290] Sonstige Maschinenbediener, ande |      1,936        0.28    
>    93.83
                [8311] Lokomotivfuehrer |        317        0.05    
>    93.88
[8312] Eisenbahnbremser, Stellwerksbedi |        536        0.08    
>    93.96
[8322] Personenkraftwagen-, Taxi- und K |      4,179        0.61    
>    94.57
[8323] Busfahrer und Strassenbahnfuehre |      1,159        0.17    
>    94.74
  [8324] Fahrer schwerer Lastkraftwagen |      3,916        0.57    
>    95.32
[8331] Fuehrer von motorisierten land-  |         59        0.01    
>    95.32
[8332] Fuehrer von Erdbewegungs- und ve |      1,690        0.25    
>    95.57
[8333] Kranfuehrer, Aufzugsmaschinisten |        383        0.06    
>    95.63
                [8334] Hubkarrenfuehrer |      1,061        0.16    
>    95.78
[8340] Deckspersonal auf Schiffen und v |         67        0.01    
>    95.79
                [9111] Strassenhaendler |         28        0.00    
>    95.80
[9131] Haushaltshilfen und Reinigungspe |      1,520        0.22    
>    96.02
[9132] Hilfskraefte und Reinigungsperso |      8,866        1.30    
>    97.32
[9141] Hausmeister, Hauswarte und verwa |      3,156        0.46    
>    97.78
[9142] Fahrzeugreiniger, Fensterputzer  |        386        0.06    
>    97.84
[9151] Boten, Paket-, Gepaecktraeger un |        988        0.14    
>    97.98
[9152] Pfoertner, Wachpersonal und verw |        863        0.13    
>    98.11
[9153] Automatenkassierer, Zaehlerables |         30        0.00    
>    98.11
                    [9161] Muellsammler |        312        0.05    
>    98.16
[9162] Strassenkehrer und verwandte Ber |         13        0.00    
>    98.16
[9211] Landwirtschaftliche Hilfsarbeite |      1,078        0.16    
>    98.32
[9212] Forstwirtschaftliche Hilfsarbeit |          9        0.00    
>    98.32
[9311] Hilfsarbeiter im Bergbau und Ste |         49        0.01    
>    98.33
[9312] Bau- und Instandhaltungshilfsarb |         32        0.00    
>    98.33
     [9313] Bauhilfsarbeiter (Gebaeude) |      1,202        0.18    
>    98.51
  [9320] Hilfsarbeiter in der Fertigung |      6,855        1.00    
>    99.51
   [9330] Transport- und Frachtarbeiter |      3,318        0.49    
>   100.00
----------------------------------------+---------------------------
> --------
                                  Total |    682,402      100.00

. 
. *** Recode employment status for respondents (I)
. 
. gen emplrel_r=1 if plb0058>0 | plb0063_v1>0 | plb0064_v2>0 | plb00
> 65>0 //Workers, apprentices, employees, public servants
(353,215 missing values generated)

. replace emplrel_r=2 if plb0057_h>0 & plb0057_h<6 // Self-employed
(28,347 real changes made)

. replace emplrel_r=3 if plb0057_h==6 // Working family member
(1,489 real changes made)

. 
. gen emplno_r=1 if plb0059==2 | plb0060==2 | plb0061==2 // 1-9 empl
> oyees
(674,770 missing values generated)

. replace emplno_r=2 if plb0059==3 | plb0060==3 | plb0061==3 // 10+ 
> employees
(1,402 real changes made)

. replace emplno_r=0 if emplno==. & emplrel_r!=.
(350,058 real changes made)

. 
. recode emplrel_r emplno_r (.=9)
(323,401 changes made to emplrel_r)
(323,310 changes made to emplno_r)

. drop plb*

. 
. **** Recode employment status for respondents (II)
. 
. tab emplrel

  emplrel_r |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |    329,210       48.24       48.24
          2 |     28,347        4.15       52.39
          3 |      1,489        0.22       52.61
          9 |    323,401       47.39      100.00
------------+-----------------------------------
      Total |    682,447      100.00

. label define emplrel_r ///
> 1 "Employee" ///
> 2 "Self-employed" ///
> 3 "Working for own family business" ///
> 9 "Missing"

. label value emplrel_r emplrel_r

. tab emplrel_r

                      emplrel_r |      Freq.     Percent        Cum.
--------------------------------+-----------------------------------
                       Employee |    329,210       48.24       48.24
                  Self-employed |     28,347        4.15       52.39
Working for own family business |      1,489        0.22       52.61
                        Missing |    323,401       47.39      100.00
--------------------------------+-----------------------------------
                          Total |    682,447      100.00

. 
. tab emplno

   emplno_r |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |    350,058       51.29       51.29
          1 |      7,677        1.12       52.42
          2 |      1,402        0.21       52.62
          9 |    323,310       47.38      100.00
------------+-----------------------------------
      Total |    682,447      100.00

. label define emplno_r ///
> 0 "0 employees" ///
> 1 "1-9 employees" ///
> 2 "10+ employees"

. label value emplno_r emplno_r

. tab emplno_r

     emplno_r |      Freq.     Percent        Cum.
--------------+-----------------------------------
  0 employees |    350,058       51.29       51.29
1-9 employees |      7,677        1.12       52.42
10+ employees |      1,402        0.21       52.62
            9 |    323,310       47.38      100.00
--------------+-----------------------------------
        Total |    682,447      100.00

. 
. gen selfem_mainjob=.
(682,447 missing values generated)

. replace selfem_mainjob=1 if emplrel_r==1 | emplrel_r==9
(652,611 real changes made)

. replace selfem_mainjob=2 if emplrel_r==2 & emplno_r==0
(19,359 real changes made)

. replace selfem_mainjob=2 if emplrel_r==3
(1,489 real changes made)

. replace selfem_mainjob=3 if emplrel_r==2 & emplno_r==1
(7,599 real changes made)

. replace selfem_mainjob=4 if emplrel_r==2 & emplno_r==2
(1,389 real changes made)

. label variable selfem_mainjob "Employment status for respondants"

. label define selfem_mainjob ///
> 1 "Not self-employed" ///
> 2 "Self-empl without employees" ///
> 3 "Self-empl with 1-9 employees" ///
> 4 "Self-empl with 10 or more"

. label value selfem_mainjob selfem_mainjob

. tab selfem_mainjob

       Employment status for |
                 respondants |      Freq.     Percent        Cum.
-----------------------------+-----------------------------------
           Not self-employed |    652,611       95.63       95.63
 Self-empl without employees |     20,848        3.05       98.68
Self-empl with 1-9 employees |      7,599        1.11       99.80
   Self-empl with 10 or more |      1,389        0.20      100.00
-----------------------------+-----------------------------------
                       Total |    682,447      100.00

. 
. *** Recode self-employment for years 2013- 
. *** Note: plb0057_h-plb0065 not recorded, but information availabl
> e in pgstib
. replace selfem_mainjob=2 if inlist(pgstib, 411, 421, 431) & ///
>                             inrange(year, 2013, 2018)
(4,530 real changes made)

. replace selfem_mainjob=3 if inlist(pgstib, 412, 422, 432) & ///
>                             inrange(year, 2013, 2018)
(2,368 real changes made)

. replace selfem_mainjob=4 if inlist(pgstib, 413, 423, 433) & ///
>                             inrange(year, 2013, 2018)
(536 real changes made)

. 
. ******************************************************************
> *************
. ** Create Oesch class schema for respondents
. ******************************************************************
> *************
. 
. gen class16_r = -9

. 
. * Large employers (1)
. 
. replace class16_r=1 if selfem_mainjob==4
(1,925 real changes made)

. 
. 
. * Self-employed professionals (2)
. 
. replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (
> isco_mainjob >= 2000 & isco_mainjob <= 2229) 
(3,738 real changes made)

. replace class16_r=2 if (selfem_mainjob==2 | selfem_mainjob==3) & (
> isco_mainjob >= 2300 & isco_mainjob <= 2470)
(5,081 real changes made)

. 
. * Small business owners with employees (3)
. 
. replace class16_r=3 if (selfem_mainjob==3) & (isco_mainjob >= 1000
>  & isco_mainjob <= 1999)
(2,374 real changes made)

. replace class16_r=3 if (selfem_mainjob==3) & (isco_mainjob >= 3000
>  & isco_mainjob <= 9333)
(4,461 real changes made)

. replace class16_r=3 if (selfem_mainjob==3) & (isco_mainjob == 2230
> )
(0 real changes made)

. 
. * Small business owners without employees (4)
. 
. replace class16_r=4 if (selfem_mainjob==2) & (isco_mainjob >= 1000
>  & isco_mainjob <= 1999)
(4,205 real changes made)

. replace class16_r=4 if (selfem_mainjob==2) & (isco_mainjob >= 3000
>  & isco_mainjob <= 9333)
(13,692 real changes made)

. replace class16_r=4 if (selfem_mainjob==2) & (isco_mainjob == 2230
> )
(0 real changes made)

. 
. * Technical experts (5)
. 
. replace class16_r=5 if (selfem_mainjob==1) & (isco_mainjob >= 2100
>  & isco_mainjob <= 2213)
(16,912 real changes made)

. 
. * Technicians (6)
. 
. replace class16_r=6 if (selfem_mainjob==1) & (isco_mainjob >= 3100
>  & isco_mainjob <= 3152)
(16,108 real changes made)

. replace class16_r=6 if (selfem_mainjob==1) & (isco_mainjob >= 3210
>  & isco_mainjob <= 3213)
(1,220 real changes made)

. replace class16_r=6 if (selfem_mainjob==1) & (isco_mainjob == 3434
> )
(0 real changes made)

. 
. * Skilled craft and production workers (7)
. 
. replace class16_r=7 if (selfem_mainjob==1) & (isco_mainjob >= 6000
>  & isco_mainjob <= 7442)
(58,629 real changes made)

. replace class16_r=7 if (selfem_mainjob==1) & (isco_mainjob >= 8310
>  & isco_mainjob <= 8312)
(849 real changes made)

. replace class16_r=7 if (selfem_mainjob==1) & (isco_mainjob >= 8324
>  & isco_mainjob <= 8330)
(3,790 real changes made)

. replace class16_r=7 if (selfem_mainjob==1) & (isco_mainjob >= 8332
>  & isco_mainjob <= 8340)
(3,170 real changes made)

. 
. * Low-skilled production workers (8)
. 
. replace class16_r=8 if (selfem_mainjob==1) & (isco_mainjob >= 8000
>  & isco_mainjob <= 8300)
(16,798 real changes made)

. replace class16_r=8 if (selfem_mainjob==1) & (isco_mainjob >= 8320
>  & isco_mainjob <= 8321)
(0 real changes made)

. replace class16_r=8 if (selfem_mainjob==1) & (isco_mainjob == 8331
> )
(59 real changes made)

. replace class16_r=8 if (selfem_mainjob==1) & (isco_mainjob >= 9153
>  & isco_mainjob <= 9333)
(12,653 real changes made)

. 
. * Higher-grade managers and administrators (9)
. 
. replace class16_r=9 if (selfem_mainjob==1) & (isco_mainjob >= 1000
>  & isco_mainjob <= 1239)
(12,258 real changes made)

. replace class16_r=9 if (selfem_mainjob==1) & (isco_mainjob >= 2400
>  & isco_mainjob <= 2429)
(6,141 real changes made)

. replace class16_r=9 if (selfem_mainjob==1) & (isco_mainjob == 2441
> )
(712 real changes made)

. replace class16_r=9 if (selfem_mainjob==1) & (isco_mainjob == 2470
> )
(6,276 real changes made)

. 
. * Lower-grade managers and administrators (10)
. 
. replace class16_r=10 if (selfem_mainjob==1) & (isco_mainjob >= 130
> 0 & isco_mainjob <= 1319)
(2,293 real changes made)

. replace class16_r=10 if (selfem_mainjob==1) & (isco_mainjob >= 340
> 0 & isco_mainjob <= 3433)
(26,946 real changes made)

. replace class16_r=10 if (selfem_mainjob==1) & (isco_mainjob >= 344
> 0 & isco_mainjob <= 3450)
(7,967 real changes made)

. 
. * Skilled clerks (11)
. 
. replace class16_r=11 if (selfem_mainjob==1) & (isco_mainjob >= 400
> 0 & isco_mainjob <= 4112)
(659 real changes made)

. replace class16_r=11 if (selfem_mainjob==1) & (isco_mainjob >= 411
> 4 & isco_mainjob <= 4210)
(34,221 real changes made)

. replace class16_r=11 if (selfem_mainjob==1) & (isco_mainjob >= 421
> 2 & isco_mainjob <= 4222)
(2,859 real changes made)

. 
. * Low-skilled clerks (12)
. 
. replace class16_r=12 if (selfem_mainjob==1) & (isco_mainjob == 411
> 3)
(291 real changes made)

. replace class16_r=12 if (selfem_mainjob==1) & (isco_mainjob == 421
> 1)
(1,932 real changes made)

. replace class16_r=12 if (selfem_mainjob==1) & (isco_mainjob == 422
> 3)
(1,096 real changes made)

. 
. * Socio-cultural professionals (13)
. 
. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob >= 222
> 0 &  isco_mainjob <= 2229)
(2,900 real changes made)

. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob >= 230
> 0 &  isco_mainjob <= 2320)
(10,629 real changes made)

. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob >= 234
> 0 &  isco_mainjob <= 2359)
(1,806 real changes made)

. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob >= 243
> 0 &  isco_mainjob <= 2440)
(411 real changes made)

. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob >= 244
> 2 &  isco_mainjob <= 2443)
(242 real changes made)

. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob == 244
> 5)
(396 real changes made)

. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob == 245
> 1)
(1,080 real changes made)

. replace class16_r=13 if (selfem_mainjob==1) & (isco_mainjob == 246
> 0)
(557 real changes made)

. 
. * Socio-cultural semi-professionals (14)
. 
. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob == 223
> 0)
(0 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob >= 233
> 0 & isco_mainjob <= 2332)
(1,460 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob == 244
> 4)
(166 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob >= 244
> 6 & isco_mainjob <= 2450)
(3,503 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob >= 245
> 2 & isco_mainjob <= 2455)
(511 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob == 320
> 0)
(0 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob >= 322
> 0 & isco_mainjob <= 3224)
(590 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob == 322
> 6)
(1,051 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob >= 322
> 9 & isco_mainjob <= 3340)
(15,915 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob >= 346
> 0 & isco_mainjob <= 3472)
(4,560 real changes made)

. replace class16_r=14 if (selfem_mainjob==1) & (isco_mainjob == 348
> 0)
(254 real changes made)

. 
. * Skilled service (15)
. 
. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob == 322
> 5)
(0 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob >= 322
> 7 & isco_mainjob <= 3228)
(669 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob >= 347
> 3 & isco_mainjob <= 3475)
(279 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob >= 500
> 0 & isco_mainjob <= 5113)
(296 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob == 512
> 2)
(4,889 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob >= 513
> 1 & isco_mainjob <= 5132)
(9,385 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob >= 514
> 0 & isco_mainjob <= 5141)
(1,841 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob == 514
> 3)
(83 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob >= 516
> 0 & isco_mainjob <= 5220)
(17,675 real changes made)

. replace class16_r=15 if (selfem_mainjob==1) & (isco_mainjob == 832
> 3)
(1,123 real changes made)

. 
. * Low-skilled service (16)
. 
. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob >= 512
> 0 & isco_mainjob <= 5121)
(1,791 real changes made)

. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob >= 512
> 3 & isco_mainjob <= 5130)
(2,947 real changes made)

. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob >= 513
> 3 & isco_mainjob <= 5139)
(662 real changes made)

. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob == 514
> 2)
(0 real changes made)

. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob == 514
> 9)
(902 real changes made)

. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob == 523
> 0)
(0 real changes made)

. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob == 832
> 2)
(3,956 real changes made)

. replace class16_r=16 if (selfem_mainjob==1) & (isco_mainjob >= 910
> 0 &  isco_mainjob <= 9152)
(15,339 real changes made)

. 
. mvdecode class16_r, mv(-9)
   class16_r: 305264 missing values generated

. label variable class16_r "Respondent's Oesch class position - 16 c
> lasses"

. label define class16_r ///
> 1 "Large employers" ///
> 2 "Self-employed professionals" ///
> 3 "Small business owners with employees" ///
> 4 "Small business owners without employees" ///
> 5 "Technical experts" ///
> 6 "Technicians" ///
> 7 "Skilled craft and production workers" ///
> 8 "Low-skilled craft and production workers" ///
> 9 "Higher-grade managers and administrators" ///
> 10 "Lower-grade managers and administrators" ///
> 11 "Skilled clerks" ///
> 12 "Low-skilled clerks" ///
> 13 "Socio-cultural professionals" ///
> 14 "Socio-cultural semi-professionals" ///
> 15 "Skilled service" ///
> 16 "Low-skilled service"

. label value class16_r class16_r

. tab class16_r

 Respondent's Oesch class position - 16 |
                                classes |      Freq.     Percent    
>     Cum.
----------------------------------------+---------------------------
> --------
                        Large employers |      1,925        0.51    
>     0.51
            Self-employed professionals |      8,819        2.34    
>     2.85
   Small business owners with employees |      6,835        1.81    
>     4.66
Small business owners without employees |     17,897        4.74    
>     9.41
                      Technical experts |     16,912        4.48    
>    13.89
                            Technicians |     17,328        4.59    
>    18.48
   Skilled craft and production workers |     66,438       17.61    
>    36.10
Low-skilled craft and production worker |     29,510        7.82    
>    43.92
Higher-grade managers and administrator |     25,387        6.73    
>    50.65
Lower-grade managers and administrators |     37,206        9.86    
>    60.52
                         Skilled clerks |     37,739       10.01    
>    70.52
                     Low-skilled clerks |      3,319        0.88    
>    71.40
           Socio-cultural professionals |     18,021        4.78    
>    76.18
      Socio-cultural semi-professionals |     28,010        7.43    
>    83.61
                        Skilled service |     36,240        9.61    
>    93.21
                    Low-skilled service |     25,597        6.79    
>   100.00
----------------------------------------+---------------------------
> --------
                                  Total |    377,183      100.00

. 
. recode class16_r (1 2=1)(3 4=2)(5 6=3)(7 8=4)(9 10=5)(11 12=6)(13 
> 14=7)(15 16=8), gen(class8_r)
(375,258 differences between class16_r and class8_r)

. label variable class8_r "Respondent's Oesch class position - 8 cla
> sses"

. label define class8_r ///
> 1 "Self-employed professionals and large employers" ///
> 2 "Small business owners" ///
> 3 "Technical (semi-)professionals" ///
> 4 "Production workers" ///
> 5 "(Associate) managers" ///
> 6 "Clerks" ///
> 7 "Socio-cultural (semi-)professionals" ///
> 8 "Service workers"

. label value class8_r class8_r

. tab class8_r

  Respondent's Oesch class position - 8 |
                                classes |      Freq.     Percent    
>     Cum.
----------------------------------------+---------------------------
> --------
Self-employed professionals and large e |     10,744        2.85    
>     2.85
                  Small business owners |     24,732        6.56    
>     9.41
         Technical (semi-)professionals |     34,240        9.08    
>    18.48
                     Production workers |     95,948       25.44    
>    43.92
                   (Associate) managers |     62,593       16.59    
>    60.52
                                 Clerks |     41,058       10.89    
>    71.40
    Socio-cultural (semi-)professionals |     46,031       12.20    
>    83.61
                        Service workers |     61,837       16.39    
>   100.00
----------------------------------------+---------------------------
> --------
                                  Total |    377,183      100.00

. 
. recode class16_r (1 2 5 9 13=1)(6 10 14=2)(3 4=3)(7 11 15=4)(8 12 
> 16=5), gen(class5_r)
(368,423 differences between class16_r and class5_r)

. label variable class5_r "Respondent's Oesch class position - 5 cla
> sses"

. label define  class5_r ///
> 1 "Higher-grade service class" ///
> 2 "Lower-grade service class" ///
> 3 "Small business owners" ///
> 4 "Skilled workers" ///
> 5 "Low-skilled workers"

. label value class5_r class5_r

. tab class5_r

  Respondent's Oesch class |
      position - 5 classes |      Freq.     Percent        Cum.
---------------------------+-----------------------------------
Higher-grade service class |     71,064       18.84       18.84
 Lower-grade service class |     82,544       21.88       40.73
     Small business owners |     24,732        6.56       47.28
           Skilled workers |    140,417       37.23       84.51
       Low-skilled workers |     58,426       15.49      100.00
---------------------------+-----------------------------------
                     Total |    377,183      100.00

. 
. 
. global class3noemp class5_r==3 & emplno_r==0 // Oesch class 3 and 
> 0 employee

. gen class4=class5_r        // recoding to 4 classes with the follo
> wing change: class5_r==3
(305,264 missing values generated)

. replace class4=2 if class5_r==3 & emplno_r==1 // 1-9 employees
(5,286 real changes made)

. replace class4=1 if $class3noemp & ((isco_>1000 & isco_<1300) | (i
> sco_>2000 & isco_<3000))
(438 real changes made)

. replace class4=2 if $class3noemp & ((isco_>=1300 & isco_<2000) | i
> sco_==2331 | isco_==2446 ///
> | (isco_>=3000 & isco_<4000))
(7,655 real changes made)

. replace class4=4 if $class3noemp & (isco_==3228 | isco_==3475 | is
> co_>=4111)
(7,131 real changes made)

. replace class4=5 if $class3noemp & (isco_==4113 | isco_==4211 | is
> co_==4223 | isco_==5121 ///
> | isco_==5123 | isco_==5133 | isco_==5139 | isco_==5149 | (isco_>8
> 000 & isco_< 8300) | isco_==8322 ///
> | isco_==8331 | (isco_>=9131 & isco_<.))
(922 real changes made)

. recode class4 (4=3) (5=4)            // 
(205,974 changes made to class4)

. label define class4_r ///
> 1 "Upper-middle class" ///
> 2 "Lower-middle class" ///
> 3 "Skilled workers" ///
> 4 "Low-skilled workers"

. label value class4 class4_r

. tab class4

             class4 |      Freq.     Percent        Cum.
--------------------+-----------------------------------
 Upper-middle class |     71,502       18.96       18.96
 Lower-middle class |     95,403       25.29       44.25
    Skilled workers |    150,930       40.02       84.27
Low-skilled workers |     59,348       15.73      100.00
--------------------+-----------------------------------
              Total |    377,183      100.00

. 
. * Adapted 6-Class Scheme
. la def class6 1 "Employers & Self-Employed Professionals" ///
>               2 "Petite Bourgeoisie" ///
>                           3 "Skilled Technical & Organizational" /
> //
>                           4 "Socio-cultural (Semi-)Professionals" 
> ///
>                           5 "Blue Collar Workers" ///
>                           6 "Lower Office & Service Functionaries"

. 
. gen class6_r = class8
(305,264 missing values generated)

. recode class6_r (1=1) (2=2) (3 5=3) (4=5) (6 8=6) (7=4)
(266,409 changes made to class6_r)

. la val class6_r class6

. 
. * Cascade replace class where missing
. sort id year

. foreach X in class16_r class8_r class5_r class4 class6_r {
  2.   bys id: replace `X' = `X'[_n-1] if missing(`X') 
  3. }
(116617 real changes made)
(116617 real changes made)
(116617 real changes made)
(116617 real changes made)
(116617 real changes made)

. 
. * Adapted 4-Class Scheme
. la def myclass4 1 "Petite Bourgeoisie" ///
>                             2 "Skilled Professionals" ///
>                             3 "Blue Collar Workers" ///
>                             4 "Lower Office & Service Functionarie
> s"

. gen myclass4_r = class6_r
(188,647 missing values generated)

. recode myclass4_r (2 = 1) (1 3 4 = 2) (5 = 3) (6 = 4)           
(493,800 changes made to myclass4_r)

. replace myclass4_r = 1 if occljob == 2 & ///
>                           inlist(ljsefsiz, 10, 11, 12, 30) & ///
>                                                   missing(myclass4
> _r)
(2,732 real changes made)

. replace myclass4_r = 2 if occljob == 2 & ///
>                           inlist(ljsefsiz, 20, 40) & ///
>                                                   missing(myclass4
> _r)
(312 real changes made)

. replace myclass4_r = 2 if (occljob == 3 & ///
>                           inlist(ljwhite, 30, 40, 50) | /// 
>                                                   occljob == 4 & /
> //
>                           inlist(ljcivs, 30, 40)) & ///
>                                                   missing(myclass4
> _r)
(10,449 real changes made)

. replace myclass4_r = 3 if occljob == 1  & ///
>                                                   missing(myclass4
> _r)
(25,859 real changes made)

. replace myclass4_r = 4 if (occljob == 3 & ///
>                           inlist(ljwhite, 10, 20, 21, 22) | /// 
>                                                   occljob == 4 & /
> //
>                           inlist(ljcivs, 10, 20)) & ///
>                                                   missing(myclass4
> _r)     
(31,045 real changes made)

. la val myclass4_r myclass4

. 
. 
. *** Assign class of household members
. clonevar myclass4 = myclass4_r
(118,250 missing values generated)

. 
. * Mode within multi-person households
. egen hh_class = mode(myclass4_r) if hh_mmb > 1, by(hh_id year)
warning: For at least one group, myclass4_r contains all missing
         values. Generating missing values for the modes in these
         groups. Use option missing to treat missing values as a
         category.
warning: Multiple modes encountered in one or more groups.
         Generating missing values for the modes in these groups.
         Use option minmode, maxmode, or nummode() to select one
         of the modes.
(346,261 missing values generated)

. 
. * In two-person households, use other person's if available
. replace myclass4 = hh_class if hh_mmb == 2 & missing(myclass4)
(16,683 real changes made)

. 
. * In multi-person household, use that of nearest neighbor by age i
> f available
. sort hh_id year age

. by hh_id year: gen nn_class = cond(age - age[_n-1] > age[_n+1] - a
> ge, ///
>                myclass4_r[_n+1], myclass4_r[_n-1]) 
(222,879 missing values generated)

. replace myclass4 = nn_class if hh_mmb > 2 & missing(myclass4)
(43,843 real changes made)

. drop nn_class

. 
. * Where still missing, assign household mode if available
. replace myclass4 = hh_class if missing(myclass4)
(7,691 real changes made)

. 
. 
. 
. ******************************************************************
> *************
. ** Task groups (Kurer)
. ******************************************************************
> *************
. 
. clonevar isco = pgisco88
(45 missing values generated)

. replace isco = . if pgisco88 < 0
(303,669 real changes made, 303,669 to missing)

. 
. * 6 Task group scheme
. gen task = .
(682,447 missing values generated)

. replace task = 1 if inlist(isco, 2411, 2431, 2441, 3411, 3471)
(3,154 real changes made)

. replace task = 1 if inrange(isco, 2100, 2213)
(19,291 real changes made)

. replace task = 1 if inrange(isco, 2443, 2444)
(472 real changes made)

. replace task = 1 if inrange(isco, 2446, 2452)
(5,565 real changes made)

. replace task = 1 if inrange(isco, 3100, 3212)
(18,365 real changes made)

. replace task = 1 if inrange(isco, 3433, 3440)
(4,241 real changes made)

. replace task = 1 if inrange(isco, 3442, 3444)
(3,505 real changes made)

. 
. replace task = 2 if inlist(isco, 2442, 2445, 3226, 3432, 3441)
(6,758 real changes made)

. replace task = 2 if inrange(isco, 1000, 1319)
(21,915 real changes made)

. replace task = 2 if inrange(isco, 2220, 2410)
(19,922 real changes made)

. replace task = 2 if inrange(isco, 2412, 2430)
(7,378 real changes made)

. replace task = 2 if inrange(isco, 2432, 2440)
(246 real changes made)

. replace task = 2 if inrange(isco, 2453, 2470)
(7,683 real changes made)

. replace task = 2 if inrange(isco, 3213, 3220)
(45 real changes made)

. replace task = 2 if inrange(isco, 3222, 3224)
(670 real changes made)

. replace task = 2 if inrange(isco, 3229, 3410)
(16,923 real changes made)

. replace task = 2 if inrange(isco, 3412, 3429)
(15,294 real changes made)

. replace task = 2 if inrange(isco, 3449, 3470)
(8,509 real changes made)

. replace task = 2 if inrange(isco, 3472, 3480)
(758 real changes made)

. 
. replace task = 3 if isco==4223
(1,130 real changes made)

. replace task = 3 if inrange(isco, 3430, 3431)
(6,265 real changes made)

. replace task = 3 if inrange(isco, 4000, 4195)
(35,910 real changes made)

. replace task = 3 if inrange(isco, 4210, 4215)
(3,302 real changes made)

. 
. replace task = 4 if inlist(isco, 7124, 8340, 9120, 9133)
(1,564 real changes made)

. replace task = 4 if inrange(isco, 1, 110) 
(1,611 real changes made)

. /* departing from oesch, including 110 (armed forces). 
>    this is the actual intention of 1-100 */
. replace task = 4 if inrange(isco, 6100, 7113)
(5,720 real changes made)

. replace task = 4 if inrange(isco, 7200, 8290)
(55,475 real changes made)

. replace task = 4 if inrange(isco, 9000, 9001)
(0 real changes made)

. replace task = 4 if inrange(isco, 9150, 9151)
(988 real changes made)

. replace task = 4 if inrange(isco, 9153, 9161)
(342 real changes made)

. replace task = 4 if inrange(isco, 9200, 9311)
(1,136 real changes made)

. 
. replace task = 5 if inlist(isco, 5122, 5143, 9002, 9162)
(5,104 real changes made)

. replace task = 5 if inrange(isco, 7120, 7123)
(3,301 real changes made)

. replace task = 5 if inrange(isco, 7129, 7143)
(16,593 real changes made)

. replace task = 5 if inrange(isco, 8300, 8334)
(13,300 real changes made)

. replace task = 5 if inrange(isco, 9130, 9132)
(10,386 real changes made)

. replace task = 5 if inrange(isco, 9140, 9142)
(3,542 real changes made)

. replace task = 5 if inrange(isco, 9312, 9313)
(1,234 real changes made)

. 
. replace task = 6 if inlist(isco, 3221, 3225, 4200, 9152)
(863 real changes made)

. replace task = 6 if inrange(isco, 3227, 3228)
(669 real changes made)

. replace task = 6 if inrange(isco, 4220, 4222)
(1,543 real changes made)

. replace task = 6 if inrange(isco, 5000, 5121)
(2,167 real changes made)

. replace task = 6 if inrange(isco, 5123, 5142)
(16,460 real changes made)

. replace task = 6 if inrange(isco, 5149, 5220)
(19,233 real changes made)

. replace task = 6 if inrange(isco, 9003, 9005)
(0 real changes made)

. replace task = 6 if inrange(isco, 9100, 9113)
(28 real changes made)

. replace task = 6 if inrange(isco, 9320, 9333) 
(10,173 real changes made)

. /* departing from oesch, including 9333 (transport labourers, anim
> al vehicles)*/
. 
. * add isco categories 2000 and 3000
. * officially not defined, thus not part of oesch's categories
. replace task = 1 if inlist(isco, 2000, 3000)
(0 real changes made)

. 
. * 99xxer category not classified..
. * whats that?? some kind of "in training/education" subgroup?
. * azubis, praktikanten, vorarbeiter, gruppenleiter, sonstige arbei
> tskraefte o.n.t.
. * o.n.t. = ohne naehere taetigkeitsangabe
. * 9910, 9920, 9930, 9942 cannot be classified (could be any indust
> ry/task)
. * 9950 = facharbeiter. most likely some routine labour.
. replace task = 4 if isco == 9950
(0 real changes made)

. 
. * 9960 = heimarbeiter. cannot be classified, could be telemarketin
> g (service) or producing paper flowers (routine)
. * 9970 / 9980 = vorarbeiter, gruppenleiter, sonstige arbeitskraeft
> e. too broad to classify. could be any task.
. /*ISCO88        Freq.   Percent Cum.
>                         
> [9332] Fuehrer v. v.Tieren gezogenen Fa 1       0.07    0.07
> [9910] Mith. Fam.Ang. ausserhalb der La 59      4.10    4.17
> [9920] Auszubildende mit (noch) nicht f 28      1.95    6.12
> [9930] Praktikanten, Volontaere ohne fe 72      5.00    11.12
> [9942] Sonstige Arbeitskraefte, arbeits 1       0.07    11.19
> [9950] Facharbeiter o.n.T.      46      3.20    14.38
> [9960] Heimarbeiter o.n.T.      76      5.28    19.67
> [9970] Vorarbeiter, Gruppenleiter       164     11.40   31.06
> [9980] Sonstige Arbeitskraefte o.n.T.   992     68.94   100.00
>                         
> Total   1,439   100.00
> */
. 
. * 3 Task Group scheme
. gen task3 = .
(682,447 missing values generated)

. replace task3 = 1 if task == 1 | task == 2
(160,694 real changes made)

. replace task3 = 2 if task == 3 | task == 4
(113,443 real changes made)

. replace task3 = 3 if task == 5 | task == 6
(104,596 real changes made)

. la def task3 1 "Non-routine cognitive" 2 "Routine" 3 "Non-routine 
> manual"

. la def task6 1 "Non-routine cognitive A" 2 "Non-routine cognitive 
> B" ///
>              3 "Routine A" 4 "Routine B" ///
>                          5 "Non-routine manual A" 6 "Non-routine m
> anual B", replace

. la val task3 task3

. la val task task6

. 
. * Cascade replace task where missing
. sort id year

. foreach X in task task3 {
  2.   bys id: replace `X' = `X'[_n-1] if missing(`X') 
  3. }
(116416 real changes made)
(116416 real changes made)

. 
. drop isco_mainjob isco

. 
. 
. ******************************************************************
> *************
. ** NACE 1.1 Sectors
. ******************************************************************
> *************
. 
. recode pgnace (-1 = .) (-2 = .a) (1/5 = 1) (11/14 = 14) (15/36 = 3
> ) ///
>               (37/41 = 4) (45 = 5) (50/52 = 6) (55 = 7) (60/64 = 8
> ) ///
>                           (65/67 = 9) (70/74 = 10) (75 = 11) (80 =
>  12) (85 = 13) ///
>                           (86/99 = 14), gen(nace)
(671,210 differences between pgnace and nace)

. la def nace 1  "A+B: Agriculture" ///
>                         3  "D: Manufacturing" ///
>                         4  "E: Energy" ///
>                         5  "F: Construction" ///
>                         6  "G: Trade" ///
>                         7  "H: Hotels/Restaurants" ///
>                         8  "I: Transport/Communication" ///
>                         9  "J: Financial Intermediation" ///
>                         10 "K: Real Estate/Business" ///
>                         11 "L: Public Administration" ///
>                         12 "M: Education" ///
>                         13 "N: Health/Social Work" ///
>                         14 "C+O+P+Q: Other (incl. Mining)" 

. la val nace nace

. 
. * Cascade replace nace where missing
. sort id year

. foreach X in nace {
  2.   bys id: replace `X' = `X'[_n-1] if missing(`X') 
  3. }
(318147 real changes made, 208477 to missing)

. 
. 
. ******************************************************************
> *************
. ** Behavior and attitudes
. ******************************************************************
> *************
. 
. * Party ID
. gen     partyid = .
(682,447 missing values generated)

. 
. * 1994-2018
. replace partyid = 0  if inrange(year, 1994, 2018) & plh0011_h == 2
>   // none
(294,747 real changes made)

. replace partyid = 1  if inrange(year, 1994, 2018) & plh0012_h == 1
>   // SPD
(78,656 real changes made)

. replace partyid = 2  if inrange(year, 1994, 2018) & inlist(plh0012
> _h, 2, 3, 13) // CDU/CSU
(89,811 real changes made)

. replace partyid = 3  if inrange(year, 1994, 2018) & plh0012_h == 4
>   // FPD
(8,568 real changes made)

. replace partyid = 4  if inrange(year, 1994, 2018) & plh0012_h == 5
>   // Grüne
(25,862 real changes made)

. replace partyid = 5  if inrange(year, 1994, 2018) & plh0012_h == 6
>   // Linke
(13,662 real changes made)

. replace partyid = 6  if inrange(year, 1994, 2018) & plh0012_h == 7
>   // Rechte (NPD/Rep/DieRechte)
(2,365 real changes made)

. replace partyid = 8  if inrange(year, 1994, 2018) & plh0012_h == 2
> 7 // Rechte (AfD)
(2,239 real changes made)

. replace partyid = 7  if inrange(year, 1994, 2018) & inrange(plh001
> 2_h,  8, 12) | ///
>                         inrange(plh0012_h, 13, 26) | ///
>   inrange(plh0012_h, 28, 31)    // Others
(10,892 real changes made)

. replace partyid = .b if inrange(year, 1994, 2018) & plh0012_h == -
> 8
(0 real changes made)

. 
. * 1984-1989
. replace partyid = 0  if inrange(year, 1984, 1989) & plh0011_h  == 
> 2 // none
(26,626 real changes made)

. replace partyid = 1  if inrange(year, 1984, 1989) & plh0012_v1 == 
> 1 // SPD
(16,477 real changes made)

. replace partyid = 2  if inrange(year, 1984, 1989) & inlist(plh0012
> _v1, 2, 4) // CDU/CSU
(10,159 real changes made)

. replace partyid = 3  if inrange(year, 1984, 1989) & plh0012_v1 == 
> 5 // FPD
(1,180 real changes made)

. replace partyid = 4  if inrange(year, 1984, 1989) & plh0012_v1 == 
> 6 // Grüne
(2,394 real changes made)

. replace partyid = 7  if inrange(year, 1984, 1989) & plh0012_v1 == 
> 7 // Others
(376 real changes made)

. replace partyid = .b if inrange(year, 1984, 1989) & plh0012_v1 == 
> -8
(0 real changes made)

. 
. * 1990 (West)
. replace partyid = 0  if year == 1990 & plh0011_h  == 2 // none
(3,902 real changes made)

. replace partyid = 1  if year == 1990 & plh0012_v2 == 1 // SPD
(2,664 real changes made)

. replace partyid = 2  if year == 1990 & inlist(plh0012_v2, 2, 4) //
>  CDU/CSU
(1,408 real changes made)

. replace partyid = 3  if year == 1990 & plh0012_v2 == 5 // FPD
(197 real changes made)

. replace partyid = 4  if year == 1990 & plh0012_v2 == 6 // Grüne
(299 real changes made)

. replace partyid = 6  if year == 1990 & plh0012_v2 == 7 // Rep
(73 real changes made)

. replace partyid = 7  if year == 1990 & plh0012_v2 == 8 // Others
(29 real changes made)

. replace partyid = .b if year == 1990 & plh0012_v2 == -8
(0 real changes made)

. 
. * 1991 (West)
. replace partyid = 0  if year == 1991 & plh0011_h  == 2 // none
(2,577 real changes made)

. replace partyid = 1  if year == 1991 & plh0012_v3 == 1 // SPD
(1,891 real changes made)

. replace partyid = 2  if year == 1991 & plh0012_v3 == 2 // CDU/CSU
(1,776 real changes made)

. replace partyid = 3  if year == 1991 & plh0012_v3 == 3 // FPD
(205 real changes made)

. replace partyid = 4  if year == 1991 & plh0012_v3 == 4 // Grüne
(218 real changes made)

. replace partyid = 4  if year == 1991 & plh0012_v3 == 5 // B90
(3 real changes made)

. replace partyid = .  if year == 1991 & plh0012_v3 == 6 // PDS
(0 real changes made)

. replace partyid = 6  if year == 1991 & plh0012_v3 == 7 // Rep
(45 real changes made)

. replace partyid = 7  if year == 1991 & plh0012_v3 == 8 // Others
(19 real changes made)

. replace partyid = .b if year == 1991 & plh0012_v3 == -8
(0 real changes made)

. 
. * 1992
. replace partyid = 0  if year == 1992 & plh0011_h  == 2 // none
(7,055 real changes made)

. replace partyid = 1  if year == 1992 & plh0012_v4 == 1 // SPD
(2,553 real changes made)

. replace partyid = 2  if year == 1992 & inlist(plh0012_v4, 2, 3) //
>  CDU/CSU
(2,104 real changes made)

. replace partyid = 3  if year == 1992 & plh0012_v4 == 4 // FPD
(248 real changes made)

. replace partyid = 4  if year == 1992 & plh0012_v4 == 5 // Grüne
(323 real changes made)

. replace partyid = 4  if year == 1992 & plh0012_v4 == 6 // B90
(80 real changes made)

. replace partyid = 5  if year == 1992 & plh0012_v4 == 7 // PDS
(126 real changes made)

. replace partyid = 7  if year == 1992 & plh0012_v4 == 8 // Others
(119 real changes made)

. replace partyid = .b if year == 1992 & plh0012_v4 == -8
(0 real changes made)

. 
. * 1993
. replace partyid = 0  if year == 1993 & plh0011_h  == 2 // none
(7,231 real changes made)

. replace partyid = 1  if year == 1993 & plh0012_v5 == 1 // SPD
(2,224 real changes made)

. replace partyid = 2  if year == 1993 & inlist(plh0012_v5, 2, 3) //
>  CDU/CSU
(1,715 real changes made)

. replace partyid = 3  if year == 1993 & plh0012_v5 == 4 // FPD
(203 real changes made)

. replace partyid = 4  if year == 1993 & plh0012_v5 == 5 // Grüne
(382 real changes made)

. replace partyid = 4  if year == 1993 & plh0012_v5 == 6 // B90
(56 real changes made)

. replace partyid = 5  if year == 1993 & plh0012_v5 == 7 // PDS
(143 real changes made)

. replace partyid = 6  if year == 1993 & plh0012_v5 == 8 // Rep
(139 real changes made)

. replace partyid = 7  if year == 1993 & plh0012_v5 == 9 // Others
(45 real changes made)

. replace partyid = .b if year == 1993 & plh0012_v5 == -8
(0 real changes made)

.                                            
. * Vote 2013                                        
. gen     vote = .
(682,447 missing values generated)

. replace vote = 0  if plh0333 == 28 // didn't vote/not eligible
(6,869 real changes made)

. replace vote = 1  if plh0333 == 1  // SPD
(9,170 real changes made)

. replace vote = 2  if inlist(plh0333, 2, 3, 13) // CDU/CSU
(12,716 real changes made)

. replace vote = 3  if plh0333 == 4  // FPD
(1,935 real changes made)

. replace vote = 4  if plh0333 == 5  // Grüne
(4,099 real changes made)

. replace vote = 5  if plh0333 == 6  // Linke
(2,882 real changes made)

. replace vote = 6  if plh0333 == 7  // Rechte (NPD/Rep/DieRechte)
(168 real changes made)

. replace vote = 8  if plh0333 == 27 // AfD
(1,938 real changes made)

. replace vote = 7  if inrange(plh0333, 8, 12) | inrange(plh0333, 13
> , 26) | ///
>                        inrange(plh0333, 29, 31) // Others
(6,221 real changes made)

. replace vote = .b if plh0333 == -8
(624,676 real changes made, 624,676 to missing)

. la def party 0 "None" 1 "SPD" 2 "CDU/CSU" 3 "FDP" 4 "Green" 5 "Lef
> t" ///
>              6 "Far Right" 7 "Others" 8 "AfD"

. la val partyid party

. la val vote  party

.                                           
. * Left-right self-placement (2005, 2009, 2014)
. clonevar lr_self = plh0004                         

.                                            
. * Worries
. clonevar wr_house = plh0029 // keep housing

. clonevar wr_ecego = plh0033 // own economic

. clonevar wr_ecnat = plh0032 // national economic

. clonevar wr_crime = plh0040 // development of crime in D

. clonevar wr_jbsec = plh0042 // job security

. clonevar wr_immig = plj0046 // immigration

. 
. * Satisfaction
. clonevar stf_life = plh0182    // life in general

. clonevar stf_work = plh0173    // work

. clonevar stf_hinc = plh0175    // HH income

. clonevar stf_pinc = plh0176    // personal income

. clonevar stf_demo = plh0152_v2 // democracy

. 
. * Willingness to take risk in job
. clonevar wttr_job = plh0200

.                 
. * Political interest
. clonevar pol_int = plh0007

. 
. * (Welfare) State attitudes (1997, 2002, 2017)
. clonevar wsa_fm1 = plh0016 

. clonevar wsa_fm2 = plh0017 

. clonevar wsa_fm3 = plh0018 

. clonevar wsa_se1 = plh0019

. clonevar wsa_se2 = plh0020

. clonevar wsa_sk1 = plh0021

. clonevar wsa_sk2 = plh0022

. clonevar wsa_ol1 = plh0023

. clonevar wsa_ol2 = plh0024

. clonevar wsa_in1 = plh0025

. clonevar wsa_in2 = plh0026

. 
. 
. ******************************************************************
> *************
. ** Housing-related variables
. ******************************************************************
> *************
. 
. *** Raw variables
. clonevar stf_larng = plj0681 // living arrangements

. clonevar stf_larea = plh0156 // area 

. clonevar stf_dwell = plh0177 // dwelling/apartment

. clonevar tie_larea = plj0043 // ties to local area

. clonevar want_move = plj0327 // Last 2 years: looking for residenc
> e (2015, 2017)

. clonevar pref_bcty = plm0580

. clonevar pref_mcty = plm0581

. clonevar pref_town = plm0582

. clonevar pref_cntr = plm0583

. 
. *** Generated variables
. * Owner/renter
. gen owner = (hgowner == 1) + 1

. replace owner = 0 if hgnorent == 1
(15,852 real changes made)

. la def owner 0 "renter (no rent)" 1 "renter" 2 "owner"

. la val owner owner

. 
. * "Kaltmiete"
. clonevar cold_rent = hgrent if hgrent >= 0  
(349,406 missing values generated)

. gen      cold_rent_sqm = cold_rent / hgsize if hgsize >= 0
(349,415 missing values generated)

. 
. * "Warmmiete"
. clonevar warm_rent = cold_rent
(349,406 missing values generated)

. replace  warm_rent = warm_rent + hgutil if hgutil >= 0
(259,427 real changes made)

. gen      warm_rent_sqm = warm_rent / hgsize if hgsize >= 0
(349,415 missing values generated)

. 
. * Rent load
. gen     cold_rent_load = cold_rent / hlc0005_h if hlc0005_h >= 0
(362,199 missing values generated)

. replace cold_rent_load = 1 if cold_rent_load > 1 & !missing(cold_r
> ent_load)
(548 real changes made)

. gen     warm_rent_load = warm_rent / hlc0005_h if hlc0005_h >= 0
(362,199 missing values generated)

. replace warm_rent_load = 1 if warm_rent_load > 1 & !missing(warm_r
> ent_load)
(909 real changes made)

. 
. * Household imputed rental value 
. /* This variable represents the imputed rental value of owner occu
> pied housing 
> and for renters with below markets rent.*/ 
. clonevar imputed_rent = i11105
(703 missing values generated)

. mvdecode imputed_rent, mv(-1 -2 -3 = . \ -5 = .a\ -8 = .b)
imputed_rent: 17284 missing values generated

. replace  imputed_rent = imputed_rent / 12
variable imputed_rent was long now double
(288,485 real changes made, 8,629 to missing)

. gen      imputed_rent_per_sqm = imputed_rent / hgsize if hgsize >=
>  0
(19,209 missing values generated)

. 
. * Home size
. gen home_size = hgsize
(703 missing values generated)

. 
. * Social housing
. recode hgrsubs (2 3 = 0) (-5 -1 = .), gen(social_housing)
(332,746 differences between hgrsubs and social_housing)

. replace social_housing = -2 if owner == 2
(3,914 real changes made)

. 
. 
. ******************************************************************
> *************
. ** Moving 
. ******************************************************************
> *************
. 
. #delim ;
delimiter now ;
. * Years since move-in;
. gen yrs_since_movein = syear - hgmoveyr if hgmoveyr >= 0 & !missin
> g(hgmoveyr);
(6,326 missing values generated)

. * Since when is household registered at current address?;
. gen hh_at_current_address = wein_v3;

. * Update based on "resmove" where missing;
. gen movein_resmove = .;
(682,447 missing values generated)

. replace movein_resmove = syear if resmove == 1;
(28,327 real changes made)

. sort id syear;

. bys id: replace movein_resmove = movein_resmove[_n-1] 
>         if missing(movein_resmove);
(79670 real changes made)

. replace yrs_since_movein = movein_resmove if missing(yrs_since_mov
> ein);
(699 real changes made)

. * Year moved into current apartment;
. gen year_of_movein = hgmoveyr if hgmoveyr >= 0 & !missing(hgmoveyr
> );
(6,326 missing values generated)

. * Movein before first interview;
. gen movein_before_entry = (year_of_movein < erstbefr) 
>         if !missing(year_of_movein);
(6,326 missing values generated)

. * Residential move;
. gen mover_tmp = 0 if !missing(year_of_movein);
(6,326 missing values generated)

. replace mover_tmp = 1 if inrange(yrs_since_movein, 0, 2) & 
>         (!inlist(hlf0107_h, -8, -5, -2) | inrange(hlf0108_h, -1, 9
> ));
(59,987 real changes made)

. clonevar mover = resmove if resmove >= 0;
(276,790 missing values generated)

. replace mover = mover_tmp if missing(mover);
(273,995 real changes made)

. drop mover_tmp;

. * Difference between resmove year and reported year;
. gen diff = movein_resmove - year_of_movein if syear >= 2001;
(575,149 missing values generated)

. * Mover typology;
. #delim ;
delimiter now ;
. gen mover_type = mover;
(2,795 missing values generated)

. replace mover_type = 1 if mover == 1 & movein_before_entry == 1;
(0 real changes made)

. replace mover_type = 2 if mover == 1 & movein_before_entry == 0 & 
>         !inrange(yrs_since_movein, 0, 2);
(107 real changes made)

. replace mover_type = 3 if mover == 1 & movein_before_entry == 0 & 
>         inrange(yrs_since_movein, 0, 2) & diff == 0;
(8,898 real changes made)

. replace mover_type = 4 if mover == 1 & movein_before_entry == 0 & 
>         inrange(yrs_since_movein, 0, 2) & diff == 1;
(18,033 real changes made)

. replace mover_type = 5 if mover == 1 & movein_before_entry == 0 & 
>         inrange(yrs_since_movein, 0, 2) & diff == 2;
(272 real changes made)

. replace mover_type = 6 if mover == 1 & movein_before_entry == 0 & 
>         inrange(yrs_since_movein, 0, 2) & !inrange(diff, 0, 2);
(19,779 real changes made)

. replace mover_type = 7 if mover == 1 & movein_before_entry == 0 & 
>         inrange(yrs_since_movein, 0, 2) & missing(diff);
(19,662 real changes made)

. la def mover_type 0 "Did not move recently" 
>         1 "Moved recently, but not after joining panel" 
>         2 "resmove recorded, but no recent reported move" 
>         3 "Moved recently, matching years" 
>         4 "Moved recently, resmove +1" 
>         5 "Moved recently, resmove +2" 
>         6 "Moved recently, resmove mismatch" 
>         7 "Moved recently, resmove missing", replace;

. la val mover_type mover_type;

. * Lag in reporting move;
. gen lag_in_reporting_move = syear - hlf0107_h if inrange(hlf0107_h
> , 1900, 2019);
(608,199 missing values generated)

. * Mover Typology 2;
. gen mover_type2 = mover;
(2,795 missing values generated)

. replace mover_type2 = 1 if mover == 1 & chg_zip == -2;
(0 real changes made)

. replace mover_type2 = 2 if mover == 1 & chg_zip == 0;
(12,006 real changes made)

. replace mover_type2 = 3 if mover == 1 & chg_zip == 1;
(17,080 real changes made)

. la def mover_type2 0 "Did not move recently" 
>         1 "Moved recently, PLZ NA" 
>         2 "Moved recently, PLZ same"
>         3 "Moved recently, PLZ changed", replace;

. la val mover_type2 mover_type2;

. # delim cr
delimiter now cr
. 
. * Reasons for moving
. clonevar reason_for_moving = hlf0108_h
(703 missing values generated)

. 
. * Reasons for moving: costs
. gen reason_for_moving_costs = 0

. replace reason_for_moving_costs = . if !inrange(hlf0108_h, 1, 9) &
>  ///
>         hlf0108_v11 != 1
(626,289 real changes made, 626,289 to missing)

. replace reason_for_moving_costs = 1 if hlf0108_v11 == 1
(3,788 real changes made)

. 
. * Reasons for moving: comfort (amenities, neighborhood, environmen
> t)
. gen reason_for_moving_comfort = 0

. replace reason_for_moving_comfort = . if !inrange(hlf0108_h, 1, 9)
>  & ///
>         (hlf0108_v12 != 1 & hlf0108_v13 != 1 &  hlf0108_v14 != 1)
(626,289 real changes made, 626,289 to missing)

. replace reason_for_moving_comfort = 1 if (hlf0108_v12 == 1 | hlf01
> 08_v13 == 1 | hlf0108_v14 == 1)
(7,492 real changes made)

. 
. 
. * Other considerations
. clonevar contact_neighbors = hlf0152
(703 missing values generated)

. clonevar moved_area_type = hlf0153_h
(703 missing values generated)

. 
. * Old vs new apartment
. clonevar moved_finances = hlf0126
(703 missing values generated)

. clonevar moved_size = hlf0127
(703 missing values generated)

. clonevar moved_furnishings = hlf0128
(703 missing values generated)

. clonevar moved_area = hlf0129
(703 missing values generated)

. clonevar moved_environment = hlf0130 
(703 missing values generated)

. clonevar moved_connections = hlf0131
(703 missing values generated)

. clonevar moved_neighborhood = hlf0132
(703 missing values generated)

. clonevar moved_contract = hlf0526
(703 missing values generated)

. 
. foreach var of varlist moved_finances - moved_contract {
  2.   mvdecode `var', mv(-1 -2 -3 = . \ -5 = .a\ -8 = .b)
  3.   replace `var' = `var' * (-1) + 2
  4.   cap _strip_labels `var'
  5. }
moved_fina~s: 626355 missing values generated
(157,422 real changes made, 116,720 to missing)
  moved_size: 625897 missing values generated
(135,470 real changes made, 116,720 to missing)
moved_furn~s: 626095 missing values generated
(137,992 real changes made, 116,720 to missing)
  moved_area: 626023 missing values generated
(144,697 real changes made, 116,720 to missing)
moved_envi~t: 626071 missing values generated
(148,911 real changes made, 116,720 to missing)
moved_conn~s: 626065 missing values generated
(154,816 real changes made, 116,720 to missing)
moved_neig~d: 626557 missing values generated
(156,652 real changes made, 116,720 to missing)
moved_cont~t: 678437 missing values generated
(630,002 real changes made, 627,816 to missing)

. egen moved_overall = rowmean(moved_finances - moved_contract)
(626,312 missing values generated)

. 
. ******************************************************************
> *************
. ** Assets
. ******************************************************************
> *************
. 
. * Define
. gen asset_re_hom_p1 = p010ha
(585,373 missing values generated)

. gen asset_re_hom_p2 = p010hb
(585,373 missing values generated)

. gen asset_re_hom_p3 = p010hc
(585,373 missing values generated)

. gen asset_re_hom_p4 = p010hd
(585,373 missing values generated)

. gen asset_re_hom_p5 = p010he
(585,373 missing values generated)

. gen asset_re_hom_m1 = p001ha
(585,373 missing values generated)

. gen asset_re_hom_m2 = p001hb
(585,373 missing values generated)

. gen asset_re_hom_m3 = p001hc
(585,373 missing values generated)

. gen asset_re_hom_m4 = p001hd
(585,373 missing values generated)

. gen asset_re_hom_m5 = p001he
(585,373 missing values generated)

. gen asset_re_hom_t1 = p011ha
(585,373 missing values generated)

. gen asset_re_hom_t2 = p011hb
(585,373 missing values generated)

. gen asset_re_hom_t3 = p011hc
(585,373 missing values generated)

. gen asset_re_hom_t4 = p011hd
(585,373 missing values generated)

. gen asset_re_hom_t5 = p011he
(585,373 missing values generated)

. gen asset_re_oth_p1 = e010ha
(585,373 missing values generated)

. gen asset_re_oth_p2 = e010hb
(585,373 missing values generated)

. gen asset_re_oth_p3 = e010hc
(585,373 missing values generated)

. gen asset_re_oth_p4 = e010hd
(585,373 missing values generated)

. gen asset_re_oth_p5 = e010he
(585,373 missing values generated)

. gen asset_re_oth_m1 = e001ha
(585,373 missing values generated)

. gen asset_re_oth_m2 = e001hb
(585,373 missing values generated)

. gen asset_re_oth_m3 = e001hc
(585,373 missing values generated)

. gen asset_re_oth_m4 = e001hd
(585,373 missing values generated)

. gen asset_re_oth_m5 = e001he
(585,373 missing values generated)

. gen asset_re_oth_t1 = asset_re_oth_p1 - asset_re_oth_m1
(585,373 missing values generated)

. gen asset_re_oth_t2 = asset_re_oth_p2 - asset_re_oth_m2
(585,373 missing values generated)

. gen asset_re_oth_t3 = asset_re_oth_p3 - asset_re_oth_m3
(585,373 missing values generated)

. gen asset_re_oth_t4 = asset_re_oth_p4 - asset_re_oth_m4
(585,373 missing values generated)

. gen asset_re_oth_t5 = asset_re_oth_p5 - asset_re_oth_m5
(585,373 missing values generated)

. gen asset_re_ttl_p1 = asset_re_hom_p1 + asset_re_oth_p1
(585,373 missing values generated)

. gen asset_re_ttl_p2 = asset_re_hom_p2 + asset_re_oth_p2
(585,373 missing values generated)

. gen asset_re_ttl_p3 = asset_re_hom_p3 + asset_re_oth_p3
(585,373 missing values generated)

. gen asset_re_ttl_p4 = asset_re_hom_p4 + asset_re_oth_p4
(585,373 missing values generated)

. gen asset_re_ttl_p5 = asset_re_hom_p5 + asset_re_oth_p5
(585,373 missing values generated)

. gen asset_re_ttl_m1 = asset_re_hom_m1 + asset_re_oth_m1
(585,373 missing values generated)

. gen asset_re_ttl_m2 = asset_re_hom_m2 + asset_re_oth_m2
(585,373 missing values generated)

. gen asset_re_ttl_m3 = asset_re_hom_m3 + asset_re_oth_m3
(585,373 missing values generated)

. gen asset_re_ttl_m4 = asset_re_hom_m4 + asset_re_oth_m4
(585,373 missing values generated)

. gen asset_re_ttl_m5 = asset_re_hom_m5 + asset_re_oth_m5
(585,373 missing values generated)

. gen asset_re_ttl_t1 = asset_re_hom_t1 + asset_re_oth_t1
(585,373 missing values generated)

. gen asset_re_ttl_t2 = asset_re_hom_t2 + asset_re_oth_t2
(585,373 missing values generated)

. gen asset_re_ttl_t3 = asset_re_hom_t3 + asset_re_oth_t3
(585,373 missing values generated)

. gen asset_re_ttl_t4 = asset_re_hom_t4 + asset_re_oth_t4
(585,373 missing values generated)

. gen asset_re_ttl_t5 = asset_re_hom_t5 + asset_re_oth_t5
(585,373 missing values generated)

. gen asset_ov_ttl_t1 = w011ha
(585,373 missing values generated)

. gen asset_ov_ttl_t2 = w011hb
(585,373 missing values generated)

. gen asset_ov_ttl_t3 = w011hc
(585,373 missing values generated)

. gen asset_ov_ttl_t4 = w011hd
(585,373 missing values generated)

. gen asset_ov_ttl_t5 = w011he
(585,373 missing values generated)

. 
. * Qualitative indicator
. la def asset_re_type 1 "does not own real estate" ///
>                      2 "mortgaged (> 50% of asset value)" ///
>                      3 "mortgaged (< 50% of asset value)" ///
>                                          4 "not mortgaged", replac
> e

. forvalues k = 1/5 {
  2.   tempvar mortgage_ratio
  3.   gen     `mortgage_ratio' = asset_re_ttl_m`k' / asset_re_ttl_p
> `k'
  4.   gen     asset_re_type`k' = .
  5.   replace asset_re_type`k' = 1 if asset_re_ttl_p`k' == 0 
  6.   replace asset_re_type`k' = 2 if asset_re_ttl_p`k' > 0 & `mort
> gage_ratio' > .5
  7.   replace asset_re_type`k' = 3 if asset_re_ttl_p`k' > 0 & `mort
> gage_ratio' <= .5
  8.   replace asset_re_type`k' = 4 if asset_re_ttl_p`k' > 0 & asset
> _re_ttl_m`k' == 0
  9.   la val  asset_re_type`k' asset_re_type
 10.   replace asset_re_type`k' = . if !inlist(year, 2002, 2007, 201
> 2, 2017)
 11. }
(628,358 missing values generated)
(682,447 missing values generated)
(42,985 real changes made)
(595,305 real changes made)
(44,157 real changes made)
(23,337 real changes made)
(577,201 real changes made, 577,201 to missing)
(628,358 missing values generated)
(682,447 missing values generated)
(42,985 real changes made)
(595,321 real changes made)
(44,141 real changes made)
(23,337 real changes made)
(577,201 real changes made, 577,201 to missing)
(628,358 missing values generated)
(682,447 missing values generated)
(42,985 real changes made)
(595,296 real changes made)
(44,166 real changes made)
(23,337 real changes made)
(577,201 real changes made, 577,201 to missing)
(628,358 missing values generated)
(682,447 missing values generated)
(42,985 real changes made)
(595,195 real changes made)
(44,267 real changes made)
(23,337 real changes made)
(577,201 real changes made, 577,201 to missing)
(628,358 missing values generated)
(682,447 missing values generated)
(42,985 real changes made)
(595,295 real changes made)
(44,167 real changes made)
(23,337 real changes made)
(577,201 real changes made, 577,201 to missing)

. 
. * Average across imputations
. egen asset_re_ttl_m = rowtotal(asset_re_ttl_m*)

. egen asset_re_ttl_p = rowtotal(asset_re_ttl_p*)

. egen asset_re_ttl_t = rowtotal(asset_re_ttl_t*)

. egen asset_ov_ttl_t = rowtotal(asset_ov_ttl_t*)

. 
. tempvar mortgage_ratio

. gen     `mortgage_ratio' = asset_re_ttl_m / asset_re_ttl_p
(628,358 missing values generated)

. gen     asset_re_type = .
(682,447 missing values generated)

. replace asset_re_type = 1 if asset_re_ttl_p == 0 
(628,358 real changes made)

. replace asset_re_type = 2 if asset_re_ttl_p > 0 & `mortgage_ratio'
>  > .5
(9,936 real changes made)

. replace asset_re_type = 3 if asset_re_ttl_p > 0 & `mortgage_ratio'
>  <= .5
(44,153 real changes made)

. replace asset_re_type = 4 if asset_re_ttl_p > 0 & asset_re_ttl_m =
> = 0
(23,337 real changes made)

. la val  asset_re_type asset_re_type

. replace asset_re_type = . if !inlist(year, 2002, 2007, 2012, 2017)
(577,201 real changes made, 577,201 to missing)

.   
.   
. ******************************************************************
> *************
. ** Additional variables
. ******************************************************************
> *************
. 
. * Union membership
. gen union = plh0263_v2

. recode union (2 = 0)
(111,607 changes made to union)

. 
. * Fractional unemployment (proportion of time unemployed since ent
> ering lf)
. mvdecode pgexpue, mv(-1) // time unemployed since lf entry in year
> s
     pgexpue: 9968 missing values generated

. mvdecode einstieg_artk einstieg_pbio, mv(-2 -1)
einstieg_a~k: 575911 missing values generated
einstieg_p~o: 52475 missing values generated

. replace einstieg_artk = einstieg_pbio if missing(einstieg_artk)
(529,154 real changes made)

. gen yrs_active = year - einstieg_artk // years since first real jo
> b
(51,777 missing values generated)

. replace yrs_active = 0 if yrs_active < 0 // labor market entry aft
> er survey year
(35,389 real changes made)

. gen unemp_frac = pgexpue / (yrs_active * 100) // fractional unempl
> oyment
(98,616 missing values generated)

. replace unemp_frac = 0 if yrs_active == 0 & lm_part == 1 // employ
> ed lf entrants
(11,518 real changes made)

. replace unemp_frac = 1 if yrs_active == 0 & lm_part == 2 // unempl
> oyed lf entrants
(2,247 real changes made)

. 
. 
. ******************************************************************
> *************
. ** Recode Missing Values
. ******************************************************************
> *************
. 
. *** Missings (standard SOEP variables)
. *       -- code only item non-response to missing . (code - 1)
. *       -- retain codes -5 (not in questionnaire version) and -8 (
> not in wave)
. *          as . a and .b
. mvdecode id-moved_area_type union-unemp_frac, mv(-1 -2 -3 = . \ -5
>  = .a\ -8 = .b)
          bl: 2 missing values generated
     hh_role: 6 missing values generated
    __000000: 39 missing values generated
        nace: 3726 missing values generated
     lr_self: 616293 missing values generated
    wr_house: 601236 missing values generated
    wr_ecego: 4747 missing values generated
    wr_ecnat: 25665 missing values generated
    wr_crime: 164660 missing values generated
    wr_jbsec: 288259 missing values generated
    wr_immig: 233614 missing values generated
    stf_life: 5893 missing values generated
    stf_work: 281811 missing values generated
    stf_hinc: 31068 missing values generated
    stf_pinc: 322214 missing values generated
    stf_demo: 611067 missing values generated
    wttr_job: 620936 missing values generated
     pol_int: 38232 missing values generated
     wsa_fm1: 619957 missing values generated
     wsa_fm2: 620074 missing values generated
     wsa_fm3: 620109 missing values generated
     wsa_se1: 619897 missing values generated
     wsa_se2: 619889 missing values generated
     wsa_sk1: 619845 missing values generated
     wsa_sk2: 619841 missing values generated
     wsa_ol1: 619804 missing values generated
     wsa_ol2: 619819 missing values generated
     wsa_in1: 619808 missing values generated
     wsa_in2: 619797 missing values generated
   stf_larng: 668106 missing values generated
   stf_larea: 610373 missing values generated
   stf_dwell: 26454 missing values generated
   tie_larea: 634333 missing values generated
   want_move: 679534 missing values generated
   pref_bcty: 677779 missing values generated
   pref_mcty: 677781 missing values generated
   pref_town: 677786 missing values generated
   pref_cntr: 677797 missing values generated
   home_size: 4222 missing values generated
social_hou~g: 318333 missing values generated
yrs_since_~n: 12 missing values generated
hh_at_curr~s: 201226 missing values generated
        diff: 1618 missing values generated
lag_in_rep~e: 6 missing values generated
reason_for~g: 625586 missing values generated
contact_ne~s: 584834 missing values generated
moved_area~e: 525379 missing values generated
       union: 552188 missing values generated

. mvdecode erstbefr, mv(-1 -2 -3 = . \ -5 = .a\ -8 = .b)
    erstbefr: 11 missing values generated

. 
. *** Missings (geo-referenced SOEP variables)
. ** From REGIONL
. * Recode
. global regionl_vars = "regbez-kr_gdp_pc"

. mvdecode $regionl_vars, mv(-1 -2 -3 = . \ -5 = .a\ -8 = .b)
      regbez: 6 missing values generated
        gbou: 526953 missing values generated
         ggk: 11 missing values generated
        gtyp: 45 missing values generated
         bik: 105328 missing values generated
     ror8595: 550112 missing values generated
         gkz: 107360 missing values generated
         kkz: 12588 missing values generated
         plz: 111912 missing values generated
      change: 682437 missing values generated
     gkzname: string variable ignored
       ror96: 145679 missing values generated
       nuts3: 12588 missing values generated
       nuts2: 12588 missing values generated
       nuts1: 12588 missing values generated
      kr_kkz: 12588 missing values generated
  kr_kkz_rek: 12588 missing values generated
kr_kkz_rek90: 211383 missing values generated
   kr_utmost: 12588 missing values generated
  kr_utmnord: 12588 missing values generated
 kr_uemprate: 202777 missing values generated
kr_foreigner: 162217 missing values generated
  kr_emprate: 189495 missing values generated
     kr_area: 12588 missing values generated
kr_populat~n: 649962 missing values generated
    kr_hhinc: 264017 missing values generated
  kr_gdp_pem: 334836 missing values generated
   kr_gdp_pc: 334836 missing values generated

. 
. * Exclude variables missing from 2005 onward
. bys syear: mdesc $regionl_vars if year >= 2005

--------------------------------------------------------------------
-> syear = 1984

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1985

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1986

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1987

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1988

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1989

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1990

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1991

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1992

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1993

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1994

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1995

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1996

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1997

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1998

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 1999

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2000

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2001

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2002

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2003

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2004

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0              0              .
           gbou |           0              0              .
            ggk |           0              0              .
           gtyp |           0              0              .
            bik |           0              0              .
        ror8595 |           0              0              .
            gkz |           0              0              .
            kkz |           0              0              .
            plz |           0              0              .
         change |           0              0              .
        gkzname |           0              0              .
       sampoint |           0              0              .
          ror96 |           0              0              .
          nuts3 |           0              0              .
          nuts2 |           0              0              .
          nuts1 |           0              0              .
         kr_kkz |           0              0              .
     kr_kkz_rek |           0              0              .
   kr_kkz_rek90 |           0              0              .
      kr_utmost |           0              0              .
     kr_utmnord |           0              0              .
    kr_uemprate |           0              0              .
   kr_foreigner |           0              0              .
     kr_emprate |           0              0              .
        kr_area |           0              0              .
   kr_populat~n |           0              0              .
       kr_hhinc |           0              0              .
     kr_gdp_pem |           0              0              .
      kr_gdp_pc |           0              0              .
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2005

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         21,105           0.00
           gbou |      21,105         21,105         100.00
            ggk |           0         21,105           0.00
           gtyp |           0         21,105           0.00
            bik |           0         21,105           0.00
        ror8595 |      21,105         21,105         100.00
            gkz |           0         21,105           0.00
            kkz |           0         21,105           0.00
            plz |           0         21,105           0.00
         change |      21,105         21,105         100.00
        gkzname |           0         21,105           0.00
       sampoint |      21,105         21,105         100.00
          ror96 |           0         21,105           0.00
          nuts3 |           0         21,105           0.00
          nuts2 |           0         21,105           0.00
          nuts1 |           0         21,105           0.00
         kr_kkz |           0         21,105           0.00
     kr_kkz_rek |           0         21,105           0.00
   kr_kkz_rek90 |         926         21,105           4.39
      kr_utmost |           0         21,105           0.00
     kr_utmnord |           0         21,105           0.00
    kr_uemprate |           0         21,105           0.00
   kr_foreigner |           0         21,105           0.00
     kr_emprate |           0         21,105           0.00
        kr_area |           0         21,105           0.00
   kr_populat~n |      21,105         21,105         100.00
       kr_hhinc |           0         21,105           0.00
     kr_gdp_pem |           0         21,105           0.00
      kr_gdp_pc |           0         21,105           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2006

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         22,358           0.00
           gbou |      22,358         22,358         100.00
            ggk |           0         22,358           0.00
           gtyp |           0         22,358           0.00
            bik |           0         22,358           0.00
        ror8595 |      22,358         22,358         100.00
            gkz |           0         22,358           0.00
            kkz |           0         22,358           0.00
            plz |           0         22,358           0.00
         change |      22,358         22,358         100.00
        gkzname |           0         22,358           0.00
       sampoint |      22,358         22,358         100.00
          ror96 |           0         22,358           0.00
          nuts3 |           0         22,358           0.00
          nuts2 |           0         22,358           0.00
          nuts1 |           0         22,358           0.00
         kr_kkz |           0         22,358           0.00
     kr_kkz_rek |           0         22,358           0.00
   kr_kkz_rek90 |         737         22,358           3.30
      kr_utmost |           0         22,358           0.00
     kr_utmnord |           0         22,358           0.00
    kr_uemprate |           0         22,358           0.00
   kr_foreigner |           0         22,358           0.00
     kr_emprate |           0         22,358           0.00
        kr_area |           0         22,358           0.00
   kr_populat~n |      22,358         22,358         100.00
       kr_hhinc |           0         22,358           0.00
     kr_gdp_pem |           0         22,358           0.00
      kr_gdp_pc |           0         22,358           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2007

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         20,886           0.00
           gbou |      20,886         20,886         100.00
            ggk |           0         20,886           0.00
           gtyp |           0         20,886           0.00
            bik |           0         20,886           0.00
        ror8595 |      20,886         20,886         100.00
            gkz |           0         20,886           0.00
            kkz |           0         20,886           0.00
            plz |           0         20,886           0.00
         change |      20,876         20,886          99.95
        gkzname |           0         20,886           0.00
       sampoint |      20,886         20,886         100.00
          ror96 |           0         20,886           0.00
          nuts3 |           0         20,886           0.00
          nuts2 |           0         20,886           0.00
          nuts1 |           0         20,886           0.00
         kr_kkz |           0         20,886           0.00
     kr_kkz_rek |           0         20,886           0.00
   kr_kkz_rek90 |         694         20,886           3.32
      kr_utmost |           0         20,886           0.00
     kr_utmnord |           0         20,886           0.00
    kr_uemprate |           0         20,886           0.00
   kr_foreigner |           0         20,886           0.00
     kr_emprate |           0         20,886           0.00
        kr_area |           0         20,886           0.00
   kr_populat~n |      20,886         20,886         100.00
       kr_hhinc |           0         20,886           0.00
     kr_gdp_pem |           0         20,886           0.00
      kr_gdp_pc |           0         20,886           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2008

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         19,684           0.00
           gbou |      19,684         19,684         100.00
            ggk |           0         19,684           0.00
           gtyp |           0         19,684           0.00
            bik |           0         19,684           0.00
        ror8595 |      19,684         19,684         100.00
            gkz |           0         19,684           0.00
            kkz |           0         19,684           0.00
            plz |           0         19,684           0.00
         change |      19,684         19,684         100.00
        gkzname |           0         19,684           0.00
       sampoint |      19,684         19,684         100.00
          ror96 |           0         19,684           0.00
          nuts3 |           0         19,684           0.00
          nuts2 |           0         19,684           0.00
          nuts1 |           0         19,684           0.00
         kr_kkz |           0         19,684           0.00
     kr_kkz_rek |           0         19,684           0.00
   kr_kkz_rek90 |         613         19,684           3.11
      kr_utmost |           0         19,684           0.00
     kr_utmnord |           0         19,684           0.00
    kr_uemprate |           0         19,684           0.00
   kr_foreigner |           0         19,684           0.00
     kr_emprate |           0         19,684           0.00
        kr_area |           0         19,684           0.00
   kr_populat~n |      19,684         19,684         100.00
       kr_hhinc |           0         19,684           0.00
     kr_gdp_pem |           0         19,684           0.00
      kr_gdp_pc |           0         19,684           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2009

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         20,792           0.00
           gbou |      20,792         20,792         100.00
            ggk |           0         20,792           0.00
           gtyp |           0         20,792           0.00
            bik |           0         20,792           0.00
        ror8595 |      20,792         20,792         100.00
            gkz |           0         20,792           0.00
            kkz |           0         20,792           0.00
            plz |           0         20,792           0.00
         change |      20,792         20,792         100.00
        gkzname |           0         20,792           0.00
       sampoint |      20,792         20,792         100.00
          ror96 |           0         20,792           0.00
          nuts3 |           0         20,792           0.00
          nuts2 |           0         20,792           0.00
          nuts1 |           0         20,792           0.00
         kr_kkz |           0         20,792           0.00
     kr_kkz_rek |           0         20,792           0.00
   kr_kkz_rek90 |         158         20,792           0.76
      kr_utmost |           0         20,792           0.00
     kr_utmnord |           0         20,792           0.00
    kr_uemprate |           0         20,792           0.00
   kr_foreigner |           0         20,792           0.00
     kr_emprate |           0         20,792           0.00
        kr_area |           0         20,792           0.00
   kr_populat~n |      20,792         20,792         100.00
       kr_hhinc |           0         20,792           0.00
     kr_gdp_pem |           0         20,792           0.00
      kr_gdp_pc |           0         20,792           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2010

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         26,720           0.00
           gbou |      26,720         26,720         100.00
            ggk |           0         26,720           0.00
           gtyp |           0         26,720           0.00
            bik |           0         26,720           0.00
        ror8595 |      26,720         26,720         100.00
            gkz |           0         26,720           0.00
            kkz |           0         26,720           0.00
            plz |           0         26,720           0.00
         change |      26,720         26,720         100.00
        gkzname |           0         26,720           0.00
       sampoint |      26,720         26,720         100.00
          ror96 |           0         26,720           0.00
          nuts3 |           0         26,720           0.00
          nuts2 |           0         26,720           0.00
          nuts1 |           0         26,720           0.00
         kr_kkz |           0         26,720           0.00
     kr_kkz_rek |           0         26,720           0.00
   kr_kkz_rek90 |         200         26,720           0.75
      kr_utmost |           0         26,720           0.00
     kr_utmnord |           0         26,720           0.00
    kr_uemprate |           0         26,720           0.00
   kr_foreigner |           0         26,720           0.00
     kr_emprate |           0         26,720           0.00
        kr_area |           0         26,720           0.00
   kr_populat~n |      26,720         26,720         100.00
       kr_hhinc |           0         26,720           0.00
     kr_gdp_pem |           0         26,720           0.00
      kr_gdp_pc |           0         26,720           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2011

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         28,733           0.00
           gbou |      28,733         28,733         100.00
            ggk |           0         28,733           0.00
           gtyp |           0         28,733           0.00
            bik |           0         28,733           0.00
        ror8595 |      28,733         28,733         100.00
            gkz |           0         28,733           0.00
            kkz |           0         28,733           0.00
            plz |           0         28,733           0.00
         change |      28,733         28,733         100.00
        gkzname |           0         28,733           0.00
       sampoint |      28,733         28,733         100.00
          ror96 |           0         28,733           0.00
          nuts3 |           0         28,733           0.00
          nuts2 |           0         28,733           0.00
          nuts1 |           0         28,733           0.00
         kr_kkz |           0         28,733           0.00
     kr_kkz_rek |           0         28,733           0.00
   kr_kkz_rek90 |         221         28,733           0.77
      kr_utmost |           0         28,733           0.00
     kr_utmnord |           0         28,733           0.00
    kr_uemprate |           0         28,733           0.00
   kr_foreigner |           0         28,733           0.00
     kr_emprate |           0         28,733           0.00
        kr_area |           0         28,733           0.00
   kr_populat~n |      28,733         28,733         100.00
       kr_hhinc |           0         28,733           0.00
     kr_gdp_pem |           0         28,733           0.00
      kr_gdp_pc |           0         28,733           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2012

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         27,983           0.00
           gbou |      27,983         27,983         100.00
            ggk |           0         27,983           0.00
           gtyp |           0         27,983           0.00
            bik |           0         27,983           0.00
        ror8595 |      27,983         27,983         100.00
            gkz |           0         27,983           0.00
            kkz |           0         27,983           0.00
            plz |           0         27,983           0.00
         change |      27,983         27,983         100.00
        gkzname |           0         27,983           0.00
       sampoint |      27,983         27,983         100.00
          ror96 |           0         27,983           0.00
          nuts3 |           0         27,983           0.00
          nuts2 |           0         27,983           0.00
          nuts1 |           0         27,983           0.00
         kr_kkz |           0         27,983           0.00
     kr_kkz_rek |           0         27,983           0.00
   kr_kkz_rek90 |          96         27,983           0.34
      kr_utmost |           0         27,983           0.00
     kr_utmnord |           0         27,983           0.00
    kr_uemprate |           0         27,983           0.00
   kr_foreigner |           0         27,983           0.00
     kr_emprate |           0         27,983           0.00
        kr_area |           0         27,983           0.00
   kr_populat~n |      27,983         27,983         100.00
       kr_hhinc |           0         27,983           0.00
     kr_gdp_pem |           0         27,983           0.00
      kr_gdp_pc |           0         27,983           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2013

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         30,956           0.00
           gbou |      30,956         30,956         100.00
            ggk |           0         30,956           0.00
           gtyp |           0         30,956           0.00
            bik |           0         30,956           0.00
        ror8595 |      30,956         30,956         100.00
            gkz |           0         30,956           0.00
            kkz |           0         30,956           0.00
            plz |           0         30,956           0.00
         change |      30,956         30,956         100.00
        gkzname |           0         30,956           0.00
       sampoint |      30,956         30,956         100.00
          ror96 |           0         30,956           0.00
          nuts3 |           0         30,956           0.00
          nuts2 |           0         30,956           0.00
          nuts1 |           0         30,956           0.00
         kr_kkz |           0         30,956           0.00
     kr_kkz_rek |           0         30,956           0.00
   kr_kkz_rek90 |         106         30,956           0.34
      kr_utmost |           0         30,956           0.00
     kr_utmnord |           0         30,956           0.00
    kr_uemprate |           0         30,956           0.00
   kr_foreigner |           0         30,956           0.00
     kr_emprate |           0         30,956           0.00
        kr_area |           0         30,956           0.00
   kr_populat~n |      30,956         30,956         100.00
       kr_hhinc |           0         30,956           0.00
     kr_gdp_pem |           0         30,956           0.00
      kr_gdp_pc |           0         30,956           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2014

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         27,465           0.00
           gbou |      27,465         27,465         100.00
            ggk |           0         27,465           0.00
           gtyp |           0         27,465           0.00
            bik |           0         27,465           0.00
        ror8595 |      27,465         27,465         100.00
            gkz |           0         27,465           0.00
            kkz |           0         27,465           0.00
            plz |           0         27,465           0.00
         change |      27,465         27,465         100.00
        gkzname |           0         27,465           0.00
       sampoint |      27,465         27,465         100.00
          ror96 |           0         27,465           0.00
          nuts3 |           0         27,465           0.00
          nuts2 |           0         27,465           0.00
          nuts1 |           0         27,465           0.00
         kr_kkz |           0         27,465           0.00
     kr_kkz_rek |           0         27,465           0.00
   kr_kkz_rek90 |         136         27,465           0.50
      kr_utmost |           0         27,465           0.00
     kr_utmnord |           0         27,465           0.00
    kr_uemprate |           0         27,465           0.00
   kr_foreigner |           0         27,465           0.00
     kr_emprate |           0         27,465           0.00
        kr_area |           0         27,465           0.00
   kr_populat~n |      27,465         27,465         100.00
       kr_hhinc |           0         27,465           0.00
     kr_gdp_pem |           0         27,465           0.00
      kr_gdp_pc |           0         27,465           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2015

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         27,183           0.00
           gbou |      27,183         27,183         100.00
            ggk |           0         27,183           0.00
           gtyp |           0         27,183           0.00
            bik |           0         27,183           0.00
        ror8595 |      27,183         27,183         100.00
            gkz |           0         27,183           0.00
            kkz |           0         27,183           0.00
            plz |           0         27,183           0.00
         change |      27,183         27,183         100.00
        gkzname |           0         27,183           0.00
       sampoint |      27,183         27,183         100.00
          ror96 |           0         27,183           0.00
          nuts3 |           0         27,183           0.00
          nuts2 |           0         27,183           0.00
          nuts1 |           0         27,183           0.00
         kr_kkz |           0         27,183           0.00
     kr_kkz_rek |           0         27,183           0.00
   kr_kkz_rek90 |          31         27,183           0.11
      kr_utmost |           0         27,183           0.00
     kr_utmnord |           0         27,183           0.00
    kr_uemprate |           0         27,183           0.00
   kr_foreigner |           0         27,183           0.00
     kr_emprate |           0         27,183           0.00
        kr_area |           0         27,183           0.00
   kr_populat~n |      27,183         27,183         100.00
       kr_hhinc |           0         27,183           0.00
     kr_gdp_pem |           0         27,183           0.00
      kr_gdp_pc |           0         27,183           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2016

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         29,116           0.00
           gbou |      29,116         29,116         100.00
            ggk |           0         29,116           0.00
           gtyp |           0         29,116           0.00
            bik |           0         29,116           0.00
        ror8595 |      29,116         29,116         100.00
            gkz |           0         29,116           0.00
            kkz |           0         29,116           0.00
            plz |           0         29,116           0.00
         change |      29,116         29,116         100.00
        gkzname |           0         29,116           0.00
       sampoint |      29,116         29,116         100.00
          ror96 |           0         29,116           0.00
          nuts3 |           0         29,116           0.00
          nuts2 |           0         29,116           0.00
          nuts1 |           0         29,116           0.00
         kr_kkz |           0         29,116           0.00
     kr_kkz_rek |           0         29,116           0.00
   kr_kkz_rek90 |         135         29,116           0.46
      kr_utmost |           0         29,116           0.00
     kr_utmnord |           0         29,116           0.00
    kr_uemprate |           0         29,116           0.00
   kr_foreigner |           0         29,116           0.00
     kr_emprate |           0         29,116           0.00
        kr_area |           0         29,116           0.00
   kr_populat~n |      29,116         29,116         100.00
       kr_hhinc |           0         29,116           0.00
     kr_gdp_pem |           0         29,116           0.00
      kr_gdp_pc |           0         29,116           0.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2017

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         32,485           0.00
           gbou |      32,485         32,485         100.00
            ggk |           0         32,485           0.00
           gtyp |           0         32,485           0.00
            bik |           0         32,485           0.00
        ror8595 |      32,485         32,485         100.00
            gkz |           0         32,485           0.00
            kkz |           0         32,485           0.00
            plz |           0         32,485           0.00
         change |      32,485         32,485         100.00
        gkzname |           0         32,485           0.00
       sampoint |      32,485         32,485         100.00
          ror96 |           0         32,485           0.00
          nuts3 |           0         32,485           0.00
          nuts2 |           0         32,485           0.00
          nuts1 |           0         32,485           0.00
         kr_kkz |           0         32,485           0.00
     kr_kkz_rek |           0         32,485           0.00
   kr_kkz_rek90 |         162         32,485           0.50
      kr_utmost |           0         32,485           0.00
     kr_utmnord |           0         32,485           0.00
    kr_uemprate |           0         32,485           0.00
   kr_foreigner |           0         32,485           0.00
     kr_emprate |           0         32,485           0.00
        kr_area |           0         32,485           0.00
   kr_populat~n |           0         32,485           0.00
       kr_hhinc |      32,485         32,485         100.00
     kr_gdp_pem |      32,485         32,485         100.00
      kr_gdp_pc |      32,485         32,485         100.00
----------------+-----------------------------------------------

--------------------------------------------------------------------
-> syear = 2018

    Variable    |     Missing          Total     Percent Missing
----------------+-----------------------------------------------
         regbez |           0         30,306           0.00
           gbou |      30,306         30,306         100.00
            ggk |           0         30,306           0.00
           gtyp |           0         30,306           0.00
            bik |           0         30,306           0.00
        ror8595 |      30,306         30,306         100.00
            gkz |           0         30,306           0.00
            kkz |           0         30,306           0.00
            plz |           0         30,306           0.00
         change |      30,306         30,306         100.00
        gkzname |           0         30,306           0.00
       sampoint |      30,306         30,306         100.00
          ror96 |           0         30,306           0.00
          nuts3 |           0         30,306           0.00
          nuts2 |           0         30,306           0.00
          nuts1 |           0         30,306           0.00
         kr_kkz |           0         30,306           0.00
     kr_kkz_rek |           0         30,306           0.00
   kr_kkz_rek90 |         126         30,306           0.42
      kr_utmost |           0         30,306           0.00
     kr_utmnord |           0         30,306           0.00
    kr_uemprate |      30,306         30,306         100.00
   kr_foreigner |      30,306         30,306         100.00
     kr_emprate |      30,306         30,306         100.00
        kr_area |           0         30,306           0.00
   kr_populat~n |      30,306         30,306         100.00
       kr_hhinc |      30,306         30,306         100.00
     kr_gdp_pem |      30,306         30,306         100.00
      kr_gdp_pc |      30,306         30,306         100.00
----------------+-----------------------------------------------

. drop gbou ror8595 sampoint kr_population

. 
. ** From MOVEDIST
. * Recode
. global movedist_vars = "resmove-chg_zip"

. mvdecode $movedist_vars, mv(-1 -2 -3 = . \ -5 = .a\ -8 = .b)
     resmove: 50988 missing values generated
    distance: 50988 missing values generated
     chg_kkz: 47239 missing values generated
     chg_zip: 48303 missing values generated

. 
. 
. ******************************************************************
> *************
. ** Weights
. ******************************************************************
> *************
. 
. * Step 1: Sample restrictions
. keep if citizen == 1 // citizens
(94,072 observations deleted)

. keep if age >= 18 // eligible to vote at federal level
(4,832 observations deleted)

. drop if inrange(psample, 16, 20) // - Flucht, Flucht/Familie, Migr
> ation 2
(7,441 observations deleted)

. drop if missing(plz) // keep only observation with zip code inform
> ation
(86,716 observations deleted)

. drop if syear < 2002 // discard pre-2002 observations
(119,790 observations deleted)

. sort id syear

. 
. * Step 2: Transform HRF to unit-mean, sum-to-N weights. Equal weig
> ht for each
. *         wave
. gen weight = xweight1

. qui: unique wave

. gen count = _N / r(unique) // equal weight to each wave

. egen sum = sum(weight), by(year)

. replace weight = weight * count / sum
(361,130 real changes made)

. drop count sum

. 
. 
. ******************************************************************
> *************
. ** Indicators for non-inclusion of attitidinal variables in waves
. ******************************************************************
> *************
. 
. foreach X of varlist partyid-moved_overall union unemp_frac {
  2.         gen niw_`X' = (`X' == .b)
  3. }

. 
. ******************************************************************
> *************
. ** Select variables
. ******************************************************************
> *************
. 
. keep psample pgexpue id-niw_union erstbefr $regionl_vars $movedist
> _vars

. 
. 
. ******************************************************************
> *************
. ** Add missing information in mover variables (using lags of KKZ a
> nd PLZ)
. ******************************************************************
> *************
. 
. sort id year

. gen plz_lag = .
(369,596 missing values generated)

. bys id: replace plz_lag = plz[_n-1]
(313580 real changes made)

. sort id year

. gen kkz_lag = .
(369,596 missing values generated)

. bys id: replace kkz_lag = kkz[_n-1]
(313580 real changes made)

. sort id year

. gen kr_kkz_rek_lag = .
(369,596 missing values generated)

. bys id: replace kr_kkz_rek_lag = kr_kkz_rek[_n-1]
(313580 real changes made)

. 
. foreach var of varlist resmove chg_kkz chg_zip {
  2.   clonevar `var'_full = `var'
  3. }
(29,687 missing values generated)
(26,885 missing values generated)
(27,809 missing values generated)

. replace resmove_full = mover if missing(resmove_full)
(29,372 real changes made)

. replace chg_kkz_full = 0 if missing(chg_kkz_full) & ///
>                             kr_kkz_rek == kr_kkz_rek_lag & ///
>                             !missing(kr_kkz_rek_lag)
(39 real changes made)

. replace chg_kkz_full = 1 if missing(chg_kkz_full) & ///
>                             kr_kkz_rek != kr_kkz_rek_lag & ///
>                             !missing(kr_kkz_rek_lag)
(11 real changes made)

. replace chg_zip_full = 0 if missing(chg_zip_full) & ///
>                             plz == plz_lag & ///
>                             !missing(plz_lag)
(767 real changes made)

. replace chg_zip_full = 1 if missing(chg_zip_full) & ///
>                             plz != plz_lag & ///
>                             !missing(plz_lag)
(121 real changes made)

. 
. 
. ******************************************************************
> *************
. ** Save
. ******************************************************************
> *************
. 
. saveold $savepath/soepv35_rents.dta, replace v(12)
(saving in Stata 12 format, which can be read by Stata 11 or 12)
(file
    /home/dcohen/work/202410_rents_replication/dat/proc-data/soepv
    > 35_rents.dta not found)
file
    /home/dcohen/work/202410_rents_replication/dat/proc-data/soepv
    > 35_rents.dta saved

. 
. log close
      name:  <unnamed>
       log:  /home/dcohen/work/202410_rents_replication/logs/01-01.l
> og
  log type:  text
 closed on:  18 Oct 2024, 11:13:56
--------------------------------------------------------------------
